Advertisement
badlogic

student subjects in a block query snippets

Sep 7th, 2017
1,150
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
Advertisement
RAW Paste Data Copied
Advertisement