sql server new users: I'm not certain that exact form runs on JET. Then again, I tend to keep SQL
on JET extremely simple. :-)

The problem is scope of reference. There are two basic ways (and several
flavors between) to do what you want:

--The kludgy way, albeit that depends on the intended maintainability
select (1+2) as t1
, (1+2) * 2 as t2
, ((1+2) * 2) * 3 as t3
from tab;

--or--
select d_t2.t1 t1
, d_t2.t2 t2
, d_t2.t2 * 3 t3
from
(
select d_t1.t1 t1
, d_t1.t1*2 t2
from
(
select (1+2) t1
from abc
) d_t1
) d_t2
;

--
Walter Clayton
Any technology distinguishable from magic is insufficiently advanced.


[quoted text, click to view]