select last_name,first_name,dept_name
from employees e left join dept_emp de on e.emp_no = de.emp_no
    left join departments ds on de.dept_no = ds.dept_no;