Calculating column from another column

[minli98]

Hi all,

I have a very basic question. Suppose I do a query to produce 3 columns: A, B and C. A and B are the results of functionA and functionB respectively. C is the sum of B and C.

So I would try,

select functionA(x) as A, functionB(x) as B, C = A + B
from tableName

But this gives me an error saying that A and B are invalid column names. How can I calculate C? Do I have to do C = functionA(x) + functionB(x) which is repetitious?

Thank you very much.

Regards,
Min

 

[jbenson001]

I believe you will have to do "C = functionA(x) + functionB(x) " as you have said, yes repetitious. I am guessing sql server doesn't recognize the A and B alias names until the query is complete. Maybe some guru can confirm or shoot down my explination.


Jim