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