User Tools

Site Tools


kurs:joins

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:joins [2010/04/16 13:36]
mh
kurs:joins [2014/09/10 21:22] (current)
Line 41: Line 41:
        ​e.employee_id(+) = m.manager_id        ​e.employee_id(+) = m.manager_id
 order by   ​m.employee_id ​     order by   ​m.employee_id ​    
 +
 +SELECT EMPLOYEES.FIRST_NAME, ​
 +       ​EMPLOYEES.LAST_NAME, ​
 +       ​MANAGER.FIRST_NAME "​MANAGER FIRST_NAME", ​
 +       ​MANAGER.LAST_NAME ​ "​MANAGER LAST_NAME" ​
 +FROM HR.EMPLOYEES right join EMPLOYEES MANAGER ​
 +on ( (EMPLOYEES.MANAGER_ID = MANAGER.EMPLOYEE_ID) )
 +where employees.employee_id is null
 +(89 rows)
 +
  
 </​code>​ </​code>​
kurs/joins.txt ยท Last modified: 2014/09/10 21:22 (external edit)