This shows you the differences between two versions of the page.
— |
kurs:eine_tabelle_mehrfach_verwenden [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | /* 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 | ||
+ | </code> |