select
e.last_name,
e.first_name,
p.dept_name
from employees e left join dept_emp d
on e.emp_no=d.emp_no
left join departments p on d.dept_no=p.dept_no