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

I got ” ORA-01417: a table may be outer joined to at most one other table ”  error in Oracle database.

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

Details of error are as follows.

ORA-01417: a table may be outer joined to at most one other table
Cause: a.b (+) = b.b and a.c (+) = c.c is not allowed

Action: Check that this is really what you want, then join b and c first in a view.

a table may be outer joined to at most one other table

This ORA-01417 error is related with the join to another table.

a.b (+) = b.b and a.c (+) = c.c is not allowed

Check that this is really what you want, then join b and c first in a view.

SELECT t1.id, t1.name, t2.t3_id FROM t1, t2, t3 WHERE t1.id = t2.id(+)
AND t3.id = t2.id(+);

To solve this error, you should remove the second outer join as follows.

SELECT t1.id, t1.name, t2.t3_id FROM t1, t2, t3 WHERE t1.id = t2.id(+)
AND t3.id = t2.id;

Do you want to learn Oracle Database for Beginners, then read the following articles.