Using computed col in same select

Hi!

I'm trying to find a way to use a computed value in the same select agein, without subselects, like this:

select a * 2 "b", "b" * 2 "c" from table;

instead of

select "b"*2 "c" from
 (select a*2 "b" from table)

Anybody knows how to do this???

Thanks in advance!

Regards

Christian Birzer Received on Mon Sep 06 1999 - 03:37:56 CDT