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

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

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


SELECT
    a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, a.DEPARTMENT_ID, b.DEPARTMENT_NAME
FROM
    EMPLOYEES a
    LEFT OUTER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
WHERE
    a.EMPLOYEE_ID = '109'
;


SELECT
    a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, a.DEPARTMENT_ID, b.DEPARTMENT_NAME
FROM
    EMPLOYEES a
    RIGHT OUTER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
WHERE
    a.EMPLOYEE_ID = '109'
;


SELECT
    a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, a.DEPARTMENT_ID, b.DEPARTMENT_NAME
FROM
    EMPLOYEES a
    RIGHT OUTER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
;


SELECT
    a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, a.DEPARTMENT_ID, b.DEPARTMENT_NAME
FROM
    EMPLOYEES a
    LEFT OUTER JOIN DEPARTMENTS_2 b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
;