SELECT e.id, e.code, e.name, e.sub_title, e.emphasis_title, e.mission_statement, e.outcomes_statement, e.list_type, e.salary_statement, e.specialization, e.description, e.note, e.grouping, e.contact_statement, e.salary_minimum, e.salary_maximum, e.salary_alternate, e.career_outlook, e.good_to_know, e.matrix, e.degree_requirements_minimum, e.degree_requirements_maximum, dg.name as degree_name, dg.code as degree_code, d.name AS division_name, d.sis_code AS division_code FROM xwncc_academics_emphasis AS e LEFT JOIN xwncc_academics_divisions AS d ON (e.division = d.id) LEFT JOIN xwncc_academics_degrees AS dg ON (dg.id = e.parent) WHERE dg.code = 'CL' AND e.code = 'mcdst' AND e.active = 'y' AND e.catalog_year = '2008'
|
||||||
|
| ||||||
|
||||||
|