SELECT DISTINCT C.LAST_NAME, C.FIRST_NAME, C.MIDDLE_NAME, B.EMPLID, C.EMAIL_ADDR FROM PS_CLASS_TBL A, PS_CLASS_INSTR B, PS_CU_BIO_VW C WHERE ( A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND A.INSTITUTION = :1 AND A.STRM = :2 AND A.SESSION_CODE = :3 AND C.EMPLID = B.EMPLID ) ORDER BY 1, 2, 3 |