Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT s.sc_crs_number, p.sc_dept_code,
- p.sc_crs_number, s.sc_dept_code,
- Conflicting_course.mainFunction(p.sc_dept_code, p.sc_crs_number,
- s.sc_dept_code, s.sc_crs_number,
- p.sc_semester, std.std_grad_year,
- secp.sec_section, secs.sec_section)
- FROM student_course p, student_course s, section secs, section secp, student std
- WHERE p.sc_dept_code = 'CSIS' AND s.sc_dept_code != 'CSIS'
- AND p.sc_semester = s.sc_semester
- AND s.sc_std_id = p.sc_std_id
- AND p.sc_crs_number >= 100 AND s.sc_crs_number >= 100
- AND p.sc_semester = 'SP2012'
- AND Conflicting_course.mainFunction(p.sc_dept_code, p.sc_crs_number,
- s.sc_dept_code, s.sc_crs_number, p.sc_semester, std.std_grad_year,
- secp.sec_section, secs.sec_section) >= 1
- ORDER BY s.sc_dept_code
Add Comment
Please, Sign In to add comment