Problems doing 3 tables outter join
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