I was wondering if you could use an alias to do math calculations: for
example,
select Bank1,
(var1 + var2) as calc,
calc*100 as var2
From......
I keep getting this message that says that calc is not in any of the
tables in the From statement. Is it possible to use a alias (calc) to
make further calculations? If so, how? Any help would be greatly
appreciated.
ocerda(at)hotmail(dot)com