How to add results of 2 $amt Oracle subquery fields

[BruceBussell]

How can you add the results of two $amount Oracle subquery fields together using their AS subquery column names

I get invalid column name errors when I try to reuse and add them together using the subquery results AS column names lower down in the main SQL script, although they display OK coming out of the subqueries.

 

[PHV]

What is your actual (wrong) SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[swampBoogie]

You can not use a column correlation name in other expressions, except in the order by clause.

The general technique is

select a + b
   from (select <expression> as a, <expression> as b, ...
            from ...) dt