Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_fatcity.com> From: Adam Turner <ATurner_at_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
Received on Tue Dec 12 2000 - 16:31:34 CST