Skip to Main Content
Forums

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 - example needed of solution

tx103108Apr 10 2009 — edited Apr 10 2009
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.

Can someone supply a simple example of a solution given tables a, b, and c?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2009
Added on Apr 10 2009
2 comments
1,319 views