Message-Id: <10708.124397@fatcity.com>
From: "Eric D. Pierce" <PierceED@csus.edu>
Date: Tue, 12 Dec 2000 14:31:34 -0800
Subject: Re: left outer to two tables ...???

Not sure exactly what the terminology in your question 
means, but here is the "classic" syntax:

---begin---

select 
       s.key1,
       x.key2,
       z.key3
  from 
       s,
       x,
       z
 where 
       s.key1 = x.key2 (+)
   and 
       s.key1 = z.key3 (+);

---end---

note the "(+)"

the above (edited from a working query) would 
give you all parent table records, regardless 
of the existence of any matching child table 
records.





On 12 Dec 2000, at 13:21, Adam Turner wrote:

Date sent:      	Tue, 12 Dec 2000 13:21:42 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
From:           	Adam Turner <ATurner@concreteinc.com>
Subject:        	left outer to two tables ...???

> can someone please send me some outer join syntax?  I am having trouble
> getting
> 
> table A left outer join table B 
> table A left outer join table C