Multiple Left Outer Joins On Same Table

[itorient]

Just wondering if it is possible to have multiple joins on the same table in Oracle. If not, what is the possible workaround? Thanks in advance for any assitance.

 

[SantaMufasa]

IT,

If you can post the simplest example of what you want, I'll try to post a solution for you.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:02 (16Feb05) UTC (aka "GMT" and "Zulu"),
@ 09:02 (16Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[itorient]

In table1, I want to use one field LEFT OUTER JOINED (+) with table2 and in table1, I use another field to LEFT OUTER JOIN (+) to table2 and one last field in table1 LEFT OUTER JOIN (+) to table3. I received an error saying "it only allows 1 most outer join". It worked in SQL SERVER. Thanks for the assistance.