Adding column aliases 1

[ecannizzo]

Consider this query:

select
case when NumLetters <>'0' and SpanishLetter = 'Yes' and Office ='NA' then NumLetters else '0' end "Nash Spanish Letters",  
case when NumLetters <>'0' and SpanishLetter <> 'Yes' and Office ='NA' then NumLetters else '0' end "Nash English Letters"
--"Nash Spanish Letters" + "Nash English Letters" "Total Letters"
from mytable

I want to be able to do the commented row, but it tells me it can't find "Nash Spanish Letters". Is there a way to do this?

Thanks!

 

[cruishall]

SELECT nash_spanish_letters + nash_english_letters total_letters
FROM (
SELECT CASE WHEN NumLetters <>'0' AND SpanishLetter = 'Yes' AND Office ='NA' THEN NumLetters
ELSE '0'
END Nash_Spanish_Letters,
CASE WHEN NumLetters <>'0' AND SpanishLetter <> 'Yes' AND Office ='NA' then NumLetters
ELSE '0'
END Nash_English_Letters
FROM mytable
)