Use of a alias in one subquery
458726Feb 1 2006 — edited Feb 2 2006Executing the command below it returns an error informing that "A1" is an invalid identification.
select 1 as a1, (select a1 as b2 from dual) as b1 from dual
Is not possible to create one alias and to use it in one subquery in the same command?
It exists another form of if getting this result?