select em.last_name,em.first_name,depa.dept_name
from (employees as em left join dept_emp as dep on em.emp_no = dep.emp_no)
left join departments as depa
on dep.dept_no = depa.dept_no