SELECT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.UNT_TAKEN_PRGRSS, A.TOT_PASSD_PRGRSS, A.TOT_CUMULATIVE, A.CUM_GPA
FROM PS_STDNT_CAR_TERM A, PS_CU_BIO_VW B
WHERE A.EMPLID = B.EMPLID
AND A.INSTITUTION = :1
AND A.ACAD_CAREER = 'GRAD'
AND A.ACAD_PROG_PRIMARY = :2
AND A.STRM = :3
ORDER BY 1, 2, 3
  • No labels