Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- C.SUBJECTID,
- C.SUBJECTCODE,
- S.SUBJECTNAME,
- C.CLASS,
- C.LECTURERCODE,
- L.FULLNAME,
- ES.UTSEXAMDATE,
- SI.UTSINPUTDATE,
- UTSSTUDENT,
- ES.UASEXAMDATE EXAMDATE,
- SI.UASINPUTDATE INPUTDATE,
- UASSTUDENT,
- C.ACTIVATEDSTATUS,
- I.STEPNAME,
- C.COURSEID,
- S.SUBJECTEXCEPTION
- FROM
- COURSE C
- JOIN MASTERDATA.STUDYPROGRAM ST ON
- (C.STUDYPROGRAMID = ST.STUDYPROGRAMID)
- LEFT JOIN SUBJECTS S ON
- (C.SUBJECTID = S.SUBJECTID)
- LEFT JOIN LECTURERTYPEVIEW L ON
- (C.LECTURERCODE = L.LECTURERCODE)
- LEFT JOIN SCORE_EXAMSCHEDULE ES ON
- (C.COURSEID = ES.COURSEID)
- LEFT JOIN SCOREINPUTSTATUS SI ON
- (C.COURSEID = SI.COURSEID)
- LEFT JOIN (
- SELECT
- COURSEID,
- MAX(STEPID) STEPID
- FROM
- SCOREINPUTSTEP
- GROUP BY
- COURSEID) SS ON
- (C.COURSEID = SS.COURSEID)
- LEFT JOIN SCOREREGISTRATIONSTEP I ON
- (SS.STEPID = I.STEPID)
- WHERE
- C.ACTIVATEDSTATUS = 'YA'
- AND C.SEMESTER = '2'
- AND C.SCHOOLYEAR = '2324'
- ORDER BY
- C.STUDYPROGRAMID,
- C.SUBJECTCODE,
- C.CLASS
Add Comment
Please, Sign In to add comment