select last_name, first_name, dept_name
from employees a
left join dept_emp b on a.emp_no=b.emp_no
left join departments c on b.dept_no=c.dept_no