Re: OUTER JOINS on Oracle 8

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/01
Message-ID: <6fsdfk$3v6@bgtnsc02.worldnet.att.net>#1/1

On Tue, 31 Mar 1998 14:10:46 +0200, "Sijmen Koffeman" <sijmen.koffeman_at_digital.com> wrote:

>Is SELECT * FROM A LEFT JOIN B ON A.x = B.x possible on Oracle8 for NT?

I believe the syntax is:

	select *
      from a,b
     where a.x = b.x(+);

Putting the (+) after the column in the B table will cause Oracle to give you ALL rows from A, and any matching rows from B. Where no matching row from B exists, Oracle will return nulls.

Oracle doesn't use "LEFT JOIN", "RIGHT JOIN". To do the opposite, move the (+), like this:

where a.x(+) = b.x;

Jonathan Received on Wed Apr 01 1998 - 00:00:00 CST