方法一,三表左连接: select e.last_name, e.first_name, dm.dept_name from employees e left join dept_emp d on e.emp_no = d.emp_no left join departments dm on dm.dept_no = d.dept_no 方法二(建立虚拟表): select t.last_name, t.first_name, dm.dept_name from ( select e.last_name,e.first_name,d.dept_no from employees e left...