题解 |使用RIGHT JOIN

SELECT emp_salary.emp_no,manager_salary.emp_no,emp_salary.salary,manager_salary.salary
FROM
(SELECT dept_manager.dept_no,dept_manager.emp_no,salaries.salary
FROM dept_manager JOIN salaries ON(dept_manager.emp_no=salaries.emp_no)) AS manager_salary
RIGHT JOIN 
(SELECT dept_emp.dept_no,dept_emp.emp_no,salaries.salary
FROM dept_emp JOIN salaries ON(dept_emp.emp_no=salaries.emp_no)) AS emp_salary
ON manager_salary.dept_no=emp_salary.dept_no
WHERE emp_salary.emp_no<>manager_salary.emp_no
AND emp_salary.salary>manager_salary.salary