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