Re: Super Newbie Question

From: Peter Ellerau <Peter.Ellerau_at_lawsonmardon.com>
Date: 1997/09/10
Message-ID: <34164BC4.6E3B@lawsonmardon.com>#1/1

defaultuser_at_domain.com wrote:
>
> Hi. I am extremely new to Oracle and have, what I hope, is a very
> elementary question for this group:
> what is the general syntax for outer joins in Oracle?
>
> In other environments I would write something like:
> "select a.*, b.* from a left outer join b on a.id = b.id"
> but this does not seem to work for Oracle.
>
> Any advice would be greatly appreciated.
>
> Len Wolfenstein
> Pacific Bell Operations Research

Hi Len

the syntax for outer joins in Oracle is:

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

;

In this examble b is the table which will be outer-joined.

Regards
Peter Ellerau Received on Wed Sep 10 1997 - 00:00:00 CDT