Outside join to two tables

[boggg1]

If I have two tables which must be joined, but one of those tables is missing some data then I use an outside join to link the two tables. That way I get data from the first table even when data from the second is absent but I get data from both tables when it is available.

My problem comes when I have to link a third table. In the Oracle I use I am not allowed two outside joins of one table to two tables. There is probably some deep reason for this but I'm not knowledgable enough to understand why.

I cannot redesign the database.

Is there a solution to this ?

 

[r937]

you are not allowed two outer joins?

perhaps the folks in one of these forums will know...

- forum185
- forum186
- forum759
- forum1177

r937.com | rudy.ca