Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    3

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

    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!!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    As one of the Forum members would say: which part of "a table may be outer joined to at most one other table" you don't understand?

    For example:
    Code:
    and a.resume_id = r.resume_id (+)  --> R is outer joined with A
    and b.resume_id = r.resume_id (+)  -->                   with B
    and d.resume_id = r.resume_id (+)  -->                   with D
    and c.resume_id = r.resume_id (+)  -->                   with C
    See? R -> A, B, C, D is invalid. You can outer join it to MAX one table. Which one? I wouldn't know. Your choice.

  3. #3
    Join Date
    Oct 2007
    Posts
    3
    like i said, im a newbie.... you don't need to get smart with me.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm not ... sorry if I made you feel that way.

    However, did you resolve the problem?

  5. #5
    Join Date
    Oct 2007
    Posts
    3
    yes, thank you

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    That restriction only applies to the old Oracle outer join syntax, I believe. If you use the ANSI "LEFT OUTER JOIN" syntax you can outer join to many tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •