SELECT
e.last_name,
e.first_name,
a.dept_name
FROM
employees e
LEFT JOIN (
SELECT *
FROM dept_emp de
JOIN departments d USING(dept_no)
) as a
ON e.emp_no=a.emp_no
SELECT
e.last_name,
e.first_name,
a.dept_name
FROM
employees e
LEFT JOIN (
SELECT *
FROM dept_emp de
JOIN departments d USING(dept_no)
) as a
ON e.emp_no=a.emp_no