select last_name,first_name,dept_name from employees e LEFT JOIN dept_emp d on e.emp_no=d.emp_no LEFT join departments dp on d.dept_no=dp.dept_no三个表进行关联，直接筛选出信息