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

600997Oct 2 2007 — edited Oct 3 2007
I am a newbie when it comes to working with tables, so any help would be greatly appreciated.

I am getting the following error when I run my SQL statement:
ORA-01417: a table may be outer joined to at most one other table

This is my SQL statement:

select p.l_name as Last,
p.f_name as First,
r.major_skills as Description,
r.resume_title as ResumeTitle,
r.objective as Objective,
p.user_id as UserID
from project_user p, resume_qual r, clearance c,
hardware_experience h, software_experience s,
experience e, industry_experience i, software_link b,
hardware_link a, industry_link d
where e.resume_id = r.resume_id (+)
and d.industry_exp_id = i.industry_exp_id (+)
and a.hardware_exp_id = h.hardware_exp_id (+)
and b.software_exp_id = s.software_exp_id (+)
and a.resume_id = r.resume_id (+)
and b.resume_id = r.resume_id (+)
and d.resume_id = r.resume_id (+)
and c.resume_id = r.resume_id (+)
and r.user_id = p.user_id

Thanks!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2007
Added on Oct 2 2007
4 comments
7,224 views