SHARE
TWEET

Untitled

a guest Jun 25th, 2019 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. prereq_subj,
  3. prereq_course,
  4. student_course_history.pidm
  5. FROM
  6. UTI_CUSTOM.COURSE_CATALOG_PREREQ
  7. LEFT JOIN
  8. uti_custom.student_course_history
  9.     ON student_course_history.subj = prereq_subj
  10.     AND student_course_history.numb = PREREQ_COURSE
  11. INNER JOIN uti_custom.student_enrollment_by_term
  12.     ON student_enrollment_by_term.pidm = student_course_history.pidm
  13.     AND student_enrollment_by_term.term = '201901'
  14.     AND student_enrollment_by_term.enrolled = 'Y'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top