-- 一句话讲解:部门员工信息 左关联 部门经理信息, 打印数据 SELECT a.emp_no, b.emp_no, a.emp_salary, b.manager_salary FROM ( SELECT t.emp_no, t.dept_no, t2.salary AS emp_salary FROM dept_emp t LEFT JOIN dept_manager t1 ON t.emp_no = t1.emp_no AND t.dept_no = t1.dept_no LEFT JOIN salaries t2 ON t.emp_no = t2.emp_no WHERE t....