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
Next revision Both sides next revision
kurs:joins [2010/04/16 13:36]
mh
kurs:joins [2014/09/10 21:22]
127.0.0.1 external edit
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: 2020/05/12 10:09 by admin