student subjects in a block query snippets

badlogic Sep 7th, 2017 (edited) 144 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT sai.stud_applicant_id,sai.ppd_firstname,cbas.block_name FROM college_block_active_semester cbas
  2. inner join college_block_subject_schedule cbss ON cbss.ccb_id = cbas.cbas_id
  3. inner join college_subject_schedule css ON css.college_subject_schedule_id = cbss.css_id
  4. inner join college_enrolled_subjects_2016_2017 ces ON ces.css_id = css.college_subject_schedule_id
  5. inner join student_applicant_information sai ON sai.stud_applicant_id = ces.sai_id
  6. WHERE ces.yl_id = 19 AND cbas.cbas_id =1
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