×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

2 Outer Joins - Is it possible?

2 Outer Joins - Is it possible?

2 Outer Joins - Is it possible?

(OP)
I am working on a report that is requiring me to do 2 different outer joins.  Is this possible?  If so, I may be missing something (hopefully not too obvious).

As a test report, I have the 3 standard tables PERSONAL_DATA (P), JOB (J), and EMPLOYMENT (E).  All are properly linked.

Outer Join #1 is to show the Supervisor's name.  I am doing an outer join with a second PERSONAL_DATA (S) table.  The link is E.SUPERVISOR_ID* = S.EMPLID.  All seems to be working just fine.  The alternative to this is removing the PERSONAL_DATA (S) table and adding the following derived field (which also works just fine):

NVL((SELECT S.NAME
FROM PS_PERSONAL_DATA S
WHERE S.EMPLID = E.SUPERVISOR_ID), '')

Outer Join #2 is to show the Reviewer's name (along with the Supervisor's name).  I am looking at data in PS_EMP_REVIEW_RVWR table.  Somehow I need to connect the REVIEWER_ID with another NAME field in the PERSONAL_DATA table.

All attempts to add this second outer join leads me to no data, just column headings.

Any thoughts???  I suspect it cannot be done – something tells me I heard somewhere that you can't do multiple outer joins.  Now I am looking for hope...  a miracle?
 

RE: 2 Outer Joins - Is it possible?

Can't you add a 3rd PERSONAL_DATA table and link
PS_EMP_REVIEW_RVWR.REVIEWER_ID to PS_PERSONAL_DATA(3).EMPLID

This is just a guess right now - let me know if it works

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close