SELECT a.last_name,a.first_name,d.dept_name FROM(SELECT e.last_name,e.first_name, c.dept_no FROM employees e LEFT JOIN dept_emp c on e.emp_no=c.emp_no) a LEFT JOIN departments d on a.dept_no=d.dept_no;