Re: Help about joins

"T. Schwickert" <schwickert_at_yahoo.com> wrote in message news:5fcc15a8.0108280616.23721f3d_at_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

As SQL92 has several levels, and all vendors except one (guess which one, right : Microsux) conform to the lowest level, I wouldn't state Oracle doesn't conform to Ansi SQL. It does, albeit to the entry level only. I definitely find the join syntax in sqlserver very confusing, and I will probably never use it, unless forced too. But then, as the join syntax is too difficult and too confusing to remember, Microsux provides a query builder.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 15:05:01 CDT