Re: reflexive joins

Try
select * from foo a1, foo a2 where a1.x > x2.x;

That is, just omit the 'as' from you statement. Jim

"Ben Newman" <ben_at_no.spam.velara.com> wrote in message news:6_To6.388$FQ3.38452_at_monger.newsread.com...
> the following sql statement will not run under oracle:
>
> select * from foo as a1, foo as a2 where a1.x > a2.x
>
> it appears as though the "as" in the from clause is not valid. can anyone
> tell me the syntax for performing such a reflexive join?
>
> thanks,
>
> ben
>
>
Received on Tue Mar 06 2001 - 08:25:10 CST