SELECT a.emp_no ,b.emp_no manager_no ,a.salary emp_salary ,b.salary manager_salary from (#员工薪水表 select de.emp_no ,de.dept_no ,s.salary from dept_emp de join salaries s on de.emp_no=s.emp_no left join dept_manager dm on de.emp_no=dm.emp_no where de.to_date='9999-01-01' and s.to_date='9999-01-01' and dm.emp_no is null )a join (#经理薪水表 select dm.emp_no ,dm.dept_no ,s.salary from dept_manager dm join salaries s on dm.emp_no=s.emp_no where dm.to_date='9999-01-01' and s.to_date='9999-01-01' )b on a.dept_no=b.dept_no and a.salary>b.salary