SELECT T1.emp_no, T2.manager_no, T1.emp_salary, T2.manager_salary FROM ( SELECT T1A.emp_no, T1A.dept_no, T1B.salary AS emp_salary FROM ( SELECT emp_no, dept_no FROM dept_emp WHERE to_date = '9999-01-01' ) T1A INNER JOIN ( SELECT emp_no, salary FROM salaries ...