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