Query SQL:

SELECT A.ACAD_GROUP, A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.CLASS_SECTION, A.DESCR, A.CLASS_NBR, A.ENRL_CAP, A.ENRL_TOT, B.ACAD_GROUP, B.ACAD_ORG, B.SUBJECT, B.CATALOG_NBR, B.CLASS_SECTION, B.DESCR, B.CLASS_NBR, B.ENRL_CAP, B.ENRL_TOT,A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM,A.SESSION_CODE,B.CRSE_ID,B.CRSE_OFFER_NBR,B.STRM,B.SESSION_CODE

  FROM PS_CLASS_TBL A, PS_CLASS_TBL B

  WHERE ( A.INSTITUTION = :1

     AND A.STRM = :2

     AND A.CLASS_STAT = 'A'

     AND A.DESCR = B.DESCR

     AND A.SUBJECT < B.SUBJECT

     AND B.STRM = :2

     AND B.INSTITUTION = :1

     AND B.CLASS_STAT = 'A' )

  ORDER BY 3, 4, 5, 12, 13

  • No labels