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