SQL Querry

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:04:36 CST