SELECT TBL_ALIAS2.PERSON_ID, TBL_ALIAS1.ORG_UNIT_CD FROM IGS_PS_OWN TBL_ALIAS1, IGS_EN_STDNT_PS_ATT_ALL TBL_ALIAS2 WHERE TBL_ALIAS1.COURSE_CD = TBL_ALIAS2.COURSE_CD AND TBL_ALIAS2.VERSION_NUMBER = TBL_ALIAS1.VERSION_NUMBER UNION ALL SELECT TBL_ALIAS2.PERSON_ID, TBL_ALIAS1.ORG_UNIT_CD FROM IGS_PS_OWN TBL_ALIAS1, IGS_AD_PS_APPL_INST_ALL TBL_ALIAS2 WHERE TBL_ALIAS1.COURSE_CD = TBL_ALIAS2.COURSE_CD AND TBL_ALIAS2.SEQUENCE_NUMBER = TBL_ALIAS1.VERSION_NUMBER
SELECT TBL_ALIAS2.PERSON_ID
, TBL_ALIAS1.ORG_UNIT_CD
FROM IGS_PS_OWN TBL_ALIAS1
, IGS_EN_STDNT_PS_ATT_ALL TBL_ALIAS2
WHERE TBL_ALIAS1.COURSE_CD = TBL_ALIAS2.COURSE_CD
AND TBL_ALIAS2.VERSION_NUMBER = TBL_ALIAS1.VERSION_NUMBER UNION ALL SELECT TBL_ALIAS2.PERSON_ID
, TBL_ALIAS1.ORG_UNIT_CD
FROM IGS_PS_OWN TBL_ALIAS1
, IGS_AD_PS_APPL_INST_ALL TBL_ALIAS2
WHERE TBL_ALIAS1.COURSE_CD = TBL_ALIAS2.COURSE_CD
AND TBL_ALIAS2.SEQUENCE_NUMBER = TBL_ALIAS1.VERSION_NUMBER
|
|
|