Use Result Set Column Names in same SELECT?

[Natha2]

Hi,
Following statement returns an error:

SELECT
AMOUNT_A + AMOUNT_B + AMOUNT_C [+ ...n] AS AMOUNT_TOT,
AMOUNT_TOT*1.21

How can I overcome this problem?
I need to do this for far more complex calculations, so it is quite critical not to do it as follows:

SELECT
AMOUNT_A + AMOUNT_B + AMOUNT_C AS AMOUNT_TOT,
(AMOUNT_A + AMOUNT_B + AMOUNT_C) *1.21

Thanx in advance for any tip!
Natha

 

[r937]

select AMOUNT_TOT
     , AMOUNT_TOT * 1.21
  from (
       select AMOUNT_A 
            + AMOUNT_B 
            + AMOUNT_C 
            + ...       as AMOUNT_TOT
         from daTable
       ) as d

r937.com | rudy.ca