Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems doing 3 tables outter join

64161Oct 26 2001
I want to do this

Select *
from Table1, Table2, Table3
where Table1.Field(+) = Table2.Field
and Table1.Field2(+) = Table3.Field


but Oracle send me an error that i can4t do more than one outter
join at same table.

I can do this in Microsoft SQL Server

Select *
from Table1, Table2, Table3
where Table1.Field =* Table2.Field
and Table1.Field2 =* Table3.Field

the diference is that SQL Server make me an LEFT outter join
and Oracle i don4t know how?

some one can help me telling me what can i do?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2001
Added on Oct 26 2001
3 comments
255 views