ORA-01417: a table may be outer joined to at most one other table

Hi,

could someone plz explain why this restriction exists. I can workaround it by creating a view with the first outer join and then outer join with this view. Shouldn't this be the same like doing it all in one statement? It seems that my workaround produces the right results. Are there any very bad performance impacts when using this workaround?

My data:

table A and B: about 100 rows
table C: about 10 million rows

outer joins:

A = B(+)
and
C = B(+) Received on Wed Aug 27 2003 - 10:52:11 CDT