select s1.emp_no emp_no,s2.emp_no manager_no,s1.salary emp_salary,s2.salary manager_salary
from (select d.emp_no,s.salary ,d.dept_no
from dept_emp d,salaries s
where d.emp_no=s.emp_no and d.to_date='9999-01-01') s1
join (select de.emp_no,s.salary ,de.dept_no
from dept_manager de,salaries s
where de.emp_no=s.emp_no and de.to_date='9999-01-01') s2
on s1.dept_no=s2.dept_no and s1.salary >s2.salary