获取员工其当前的薪水比其manager当前薪水还高

select es.emp_no,ms.manager_no,es.emp_salary,ms.manager_salary 
from 
#创建员工工资表
(select s.emp_no,de.dept_no,s.salary as emp_salary 
from salaries s
join dept_emp de on s.emp_no=de.emp_no
where s.emp_no not in (select emp_no from dept_manager
where to_date='9999-01-01')) as es
join 
#创建manager工资表
(select s.emp_no as manager_no,de.dept_no,s.salary as manager_salary
from salaries s
join dept_emp de  on s.emp_no=de.emp_no 
where s.emp_no in (select emp_no from dept_manager
where to_date='9999-01-01')) as ms 
on es.dept_no= ms.dept_no #表连接
where es.emp_salary>ms.manager_salary