outer joins to more than one table

[Kebabmeister]

Hi All

I have a query when I want to outer join to more than one table. Using standard PLsql I get the following "ORA-01417: a table may be outer joined to at most one other table". My question: does ANSI sql have an answer to this?

 

[r937]

in ANSI SQL, and in most database systems, yes, you can outer join to more than one table

if you were to post your problem in one of the oracle forums, i'm sure those guys can help you

r937.com | rudy.ca