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 = 'AAS'
	AND e.code = 'act'
	AND e.active = 'y'
	AND e.catalog_year = '2008'