Re: Help about joins

From: T. Schwickert <schwickert_at_yahoo.com>
Date: 28 Aug 2001 07:16:43 -0700
Message-ID: <5fcc15a8.0108280616.23721f3d@posting.google.com>

Hi,

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> Check the sql reference manual and you will notice LEFT JOIN doesn't exist
> in Oracle SQL
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA

thats right for oracle before 9i.
But it's unbelievable, oracle just made it to get more and more ansi conform :-) and itroduced left/right/full outer join I don't have 9i running, so just guessing:

select a.c1,b.c1,c.c1
from tab1 a
left outer join tab2 b
on a.c1=b.c1
left outer join tab3 c
on b.c1 = c.c1

However, not before 9i ...

Hth
Thomas Received on Tue Aug 28 2001 - 09:16:43 CDT