-- INNER JOIN (Muestra los registros que coincide el discriminante en ambas tablas)
SELECT * FROM employees
INNER JOIN departments ON employees.department_id = departments.department_id
WHERE employee_id between 168 and 178;

-- LEFT JOIN
SELECT * FROM employees
LEFT JOIN departments ON employees.department_id = departments.department_id
WHERE employee_id between 168 and 178;


-- RIGHT JOIN
SELECT * FROM employees
RIGHT JOIN departments ON employees.department_id = departments.department_id
WHERE employee_id between 168 and 178 OR employee_id IS NULL ;

