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

只需要表连接好就行了