FireGeek21
Technical User
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?
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?