-- Соединение таблиц. LEFT JOIN
-- https://www.youtube.com/watch?v=O57gQ3c0aEk

-------------------------------------------
-- Примеры команд SQL в рамках урока #18


select * from DEPARTMENTS_2
;

select 
    a.*, b.DEPARTMENT_NAME
from 
    EMPLOYEES a
    inner join DEPARTMENTS_2 b on a.DEPARTMENT_ID = b.DEPARTMENT_ID
;

select 
    a.*, b.DEPARTMENT_NAME
from 
    EMPLOYEES a
    Left outer join DEPARTMENTS_2 b on a.DEPARTMENT_ID = b.DEPARTMENT_ID
;

select 
    a.*, b.DEPARTMENT_NAME
from 
    EMPLOYEES a
    left outer join DEPARTMENTS b on a.DEPARTMENT_ID = b.DEPARTMENT_ID
;