SELECT f.emp_no, e.manager_no, f.salary, e.salary from (select -- 拉一张全员的薪资清单 b.emp_no, b.dept_no, d.salary from dept_emp b left join salaries d on b.emp_no = d.emp_no and d.to_date='9999-...