sql=SELECT xc.categoryid,xc.category FROM `univ_degrees` ud INNER JOIN univ_cip_key uck ON ud.degreeid = uck.degreeid INNER JOIN career_crosswalk ccw ON uck.cip_code = ccw.CIP_Code INNER JOIN xcart_categories xc ON ccw.onetsoccode = xc.fk_onetsoccode WHERE ud.deguid = '66585' AND xc.datatype = 'cr.cluster.career' ORDER BY xc.order_by
Rowan - Cabarrus Community College Certificates/Less-than-2-year certificate Computer Programming + Programmer General
Rowan - Cabarrus Community College Certificates/Less-than-2-year...