...SAN FRANCISCO DEVELOPMENT,TESTING,MEDIA
JOBY SAN DIEGO TESTING,MEDIA,ADVERTISING
I was hoping I could do something like
SELECT *,GROUP_CONCAT(SELECT dept.departmentname FROM departments dept WHERE dept.did IN jobs.depts) as deptnames FROM jobs,locations loc WHERE...