Re: Support for LEFT JOIN's ???

From: John Seitz <seitz_at_pobox.com>
Date: Tue, 01 Jun 1999 02:40:16 GMT
Message-ID: <37534837.52D24127@pobox.com>

Oracle doesn't support Left Outer Join syntax any more. To do outer joins you have to use the (+) syntax.

Example of Left outer join

Select * from Table1, Table2
where Table1.Field1 = Table2.Field2 (+)

example of Right outer join
Select * from Table1, Table2
where Table1.Field1(+) = Table2.Field2

notice the difference in the placement of the (+). To do a FULL outer join, do a union of a Left and Right outer join.

John

"J. Taylor" wrote:

> Does Oracle 8 support the "LEFT JOIN" SQL statement (SQL-92 standard)???
> If so, how...?? We can not get this to work.....in a VB 6.0 (ADO) Win NT 4.0
> environment.
>
> Thanks
Received on Mon May 31 1999 - 21:40:16 CDT