User Tools

Site Tools


kurs:eine_tabelle_mehrfach_verwenden

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
kurs/eine_tabelle_mehrfach_verwenden.txt · Last modified: 2014/09/10 21:22 (external edit)