/* Formatted on 2007/11/16 19:56 (Formatter Plus v4.8.6) */ SELECT m.first_name, m.last_name, ' manages ', a.first_name, a.last_name FROM employees a, departments, employees m WHERE (departments.department_id = a.department_id) and departments.manager_id = m.employee_id order by m.last_name, a.last_name