Re: reflexive joins

From: The Ghost <The_at_Ghost.com>
Date: Mon, 05 Mar 2001 22:25:30 GMT
Message-ID: <unUo6.27895$c7.8104175@news3.rdc1.on.home.com>

SELECT * FROM FOO A1
WHERE X=A1.X "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 Mon Mar 05 2001 - 16:25:30 CST