dokuwiki

/* 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