Re: JOINS in Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 Nov 2000 18:55:29 +0100
Message-ID: <974744310.11943.0.pluto.d4ee154e@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 - 11:55:29 CST