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

#将员工信息和工资表连接起来
# select t1.emp_no e1,t1.dept_no d1,t2.dept_no d2,t2.emp_no e2,salary s
# from dept_emp t1 left join dept_manager t2 on (t1.dept_no=t2.dept_no) join salaries on (t1.emp_no=salaries.emp_no)

select e1,e2,s,salary
from (select t1.emp_no e1,t1.dept_no d1,t2.dept_no d2,t2.emp_no e2,salary s
from dept_emp t1 left join dept_manager t2 on (t1.dept_no=t2.dept_no) join salaries on (t1.emp_no=salaries.emp_no))tt left join salaries on (tt.e2 = salaries.emp_no)
where s-salary > 0