Re: JOINS in Oracle

From: Willy Gielen <wgielen_at_quintessence.net>
Date: Tue, 21 Nov 2000 00:45:13 +0100
Message-ID: <8vcd90$tbl$05$1@news.t-online.com>

Thanks Sybrand,

it wasn't quite the answer I was hoping for, but now at least I know what I have to do...

Willy

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:974744310.11943.0.pluto.d4ee154e_at_news.demon.nl...
> You have to rewrite your selects.
> Both methods of defining joins are ANSI compliant, albeit on a different
> level of the standard.
> Personally, I think the SQL server method becomes completely inlegible
when
> applying more than 2 joins.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>
> "Willy Gielen" <wgielen_at_quintessence.net> wrote in message
> news:8vbmrt$u43$03$1_at_news.t-online.com...
> > we have an SQL Server application that uses JOINs extensively.
> > Is there any way to use the JOIN operator in Oracle or do we have to
rewrite
> > our selects?
> > What does ANSI SQL say on this matter?
> >
> > Thanks
> > Willy
> >
> >
>
>
Received on Mon Nov 20 2000 - 17:45:13 CST