select t.last_name,t.first_name,t3.dept_name from employees t left join
(select * from departments t1 left join dept_emp t2 on t1.dept_no=t2.dept_no)t3
on t.emp_no =t3.emp_no