ORA-01417: a table may be outer joined to at most one other table
847557Mar 15 2011 — edited Mar 15 2011I have a SQL statement that runs fine in Sybase that I need to run in Oracle. However, Oracle generates the subject line error (abovSQL statement runs fine in Sybase. There are 3 tables involved in the outer join as follows:
SELECT *
FROM A, I, PT
WHERE
A.id = I.id and
A.number = I.number and
A.vno= I.vno and
I.id = PT.id (+) and
I.vno = PT.vno(+) and
A.format = PT.format (+)
As you can see, table "PT" needs to be outer joined to table "I" and table "A" however, Oracle does not allow a table to be outer joined to more than one table (per error message above).
Does anyone have any suggestions to solve this limitation? Also, any solution should be limited to changing the above SQL statement only.
Thanks in advance.