Results Sample
Query SQL:
SELECT A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.SESSION_CODE, A.CLASS_NBR, B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID,A.ACAD_CAREER,A.INSTITUTION,A.STRM
FROM PS_CLASS_TBL_SE_VW A, PS_CU_BIO_VW B
WHERE A.INSTITUTION = :1
AND A.STRM = :2
AND ( A.SUBJECT = :3
OR :3 IS NULL)
AND B.EMPLID = A.EMPLID
AND A.STDNT_ENRL_STATUS = 'E'
ORDER BY 1, 2, 4, 7, 8, 9