RE: operation with alias

2006-07-27 Thread Jay Blanchard
[snip] i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't want to make again the su

operation with alias

2006-07-27 Thread obed
Hi all, it's me again jeje !!! i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't