题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

-- 一句话讲解：部门员工信息 左关联 部门经理信息， 打印数据 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.emp_no NOT IN ( SELECT emp_no FROM dept_manager ) ) a LEFT JOIN ( SELECT t.emp_no, t.dept_no, t2.salary AS manager_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.emp_no IN ( SELECT emp_no FROM dept_manager ) ) b ON a.dept_no = b.dept_no WHERE a.emp_salary > b.manager_salary