Re: OUTER JOINS on Oracle 8

From: <bialik_at_wis.weizmann.ac.il>
Date: 1998/04/04
Message-ID: <6g5v21$bnc$1@nnrp1.dejanews.com>#1/1

Hi.
No problem with outer join in Oracle.
You just write

 SELECT * FROM A, B WHERE A.X = B.X (+) or
 ....               WHERE A.X(+) = B.X
 for LEFT/RIGHT outer joins.

In article <6fqmf6$4iq$1_at_sniff.shr.dec.com>, "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'm quite new to Oracle you see...)
>
> Thanks in advance!
>
> Sijmen Koffeman.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Apr 04 1998 - 00:00:00 CST