From: "Heinz Juergens" <juergens@acm.org>
Subject: Re: Super Newbie Question
Date: 1997/09/09
Message-ID: <01bcbd77$6d7567e0$720101c8@tempo2>#1/1
References: <34154FE4.AD16B0F6@msg.pacbell.com>
Organization: Unisource Business Networks
Newsgroups: comp.databases.oracle.misc





defaultuser@domain.com schrieb im Beitrag
<34154FE4.AD16B0F6@msg.pacbell.com>...
> 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
> 
For your example you should use:

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

You will receive all rows from b and the values from a, if avaliable

Heinz (juergens@computer.org)