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

-- Соединение таблиц. 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
;