Re: reflexive joins

From: Jim Wolfe <jim_wolfe_at_sra.com>
Date: Tue, 06 Mar 2001 14:25:10 GMT
Message-ID: <ar6p6.345$oz.50194_at_newsread1.prod.itd.earthlink.net>


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 - 15:25:10 CET

Original text of this message