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

这个题目里面，我们需要使用dept_no进行连接

select user_salary.emp_no,manager_salary.emp_no,user_salary.salary,manager_salary.salary from 
(select a.emp_no, c.salary , a.dept_no from dept_emp a, salaries c where a.emp_no = c.emp_no) as user_salary
inner join 
(select b.emp_no, c.salary ,b.dept_no from dept_manager b, salaries c where b.emp_no = c.emp_no) as manager_salary 
where user_salary.dept_no = manager_salary.dept_no and user_salary.salary > manager_salary.salary