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 ?
![[bigglasses]](/data/assets/smilies/bigglasses.gif "[bigglasses] [bigglasses]")
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 ?
