SELECT DISTINCT A.department_id,A.department_name FROM departments A INNER JOIN photo_album C ON A.department_id=C.photo_album_department_id WHERE A.department_status='Y' AND A.division_id='' ORDER BY A.department_name ASC
Institute of Management