Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

847557Mar 15 2011 — edited Mar 15 2011
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2011
Added on Mar 15 2011
4 comments
12,823 views