You might try:
select a.field1, a.field2, b.field3, b.field4, c.field5
from a, b, c
where a.field1 = b.field3 (+)
and a.field1 = c.field5 (+)
User554420 wrote in message
<19990223000436.21910.00001596_at_ng-da1.aol.com>...
>I have a query with several outer joins. For example
> tables a, b, c
>
>select a.field1, a.field2, b.field3, b.field4, c.field5
>from a, b, c
>where a.field1 = b.field3 (+) and
> b.field3 = c.field5 (+)
>
>I'm not getting any rows back when there is no data for tables b & c. I
could
>put this into a couple subqueries, but is there a better way.
>
>Thanks.
>
Received on Mon Feb 22 1999 - 23:50:02 CST
