SELECT A.EMPLID, B.FIRST_NAME, B.MIDDLE_NAME, B.LAST_NAME, C.EMAIL_ADDR
FROM PS_STDNT_CAR_TERM A, PS_CU_BIO_VW B, PS_SCC_EMAIL_QVW C
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.UNT_TAKEN_PRGRSS > 0
AND A.EMPLID = B.EMPLID
AND A.EMPLID = C.EMPLID (+)
AND 'CAMP' = C.E_ADDR_TYPE(+) )
ORDER BY 4, 2
  • No labels