select t2.last_name,t2.first_name,t2.dept_name from (select t.*,d2.dept_name from (select e.emp_no,d1.dept_no,e.last_name,e.first_name from employees e left join dept_emp d1 on e.emp_no=d1.emp_no)t left join departments d2 on t.dept_no= d2.dept_no)t2;