×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Text
Posted by: sumesh tg
Added: Dec 2, 2016 11:12 AM
Views: 7
  1. SELECT secco.college_id,campp.campus_id,basic.campuses FROM search_edu_college_courses_offered secco
  2. LEFT JOIN search_edu_providers provider on provider.college_id=secco.college_id
  3. LEFT JOIN search_edu_course_basics basic on basic.course_id=secco.course_id
  4. LEFT JOIN  search_edu_college_campuses campp on FIND_IN_SET(campp.campus_id,basic.campuses)
  5. WHERE secco.program_field LIKE '%bb%'