Versions Compared

Old Version 1

changes.mady.by.user Tabassum Lodhi

Saved on

compared with

New Version Current

changes.mady.by.user Tabassum Lodhi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 
 
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