reflexive joins
From: Ben Newman <ben_at_no.spam.velara.com>
Date: Mon, 05 Mar 2001 21:58:26 GMT
Message-ID: <6_To6.388$FQ3.38452_at_monger.newsread.com>
Date: Mon, 05 Mar 2001 21:58:26 GMT
Message-ID: <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 Mon Mar 05 2001 - 22:58:26 CET