SELECT last_name, first_name, dept_name
FROM employees e
LEFT JOIN dept_emp d1 on e.emp_no = d1.emp_no
LEFT JOIN departments d2 on d1.dept_no = d2.dept_no