Cory Nelson wrote:
> > Can anybody tell me, what is wrong with this simple query:
> >
> > select a, (select c
> > from (select b + 1 as c) as Table2) as d
> > from (select 1 as a, 2 as b) as Table1
>
> I don't claim to be a master of SQL, but isn't "select b + 1 as c" its
> own query, without access to the "2 as b" in the outer query?
But this query is work well:
select a, (select b + 1 as c) as d
from (select 1 as a, 2 as b) as Table1
The problem is only with subqueries nested in another subquery.
--
Best regards,
Alexander mailto:[EMAIL PROTECTED]
