select distinct s.emp_no, m.emp_no, s.salary, managersalary.salary from salaries s join dept_emp de on de.emp_no=s.emp_no join dept_manager m on m.dept_no=de.dept_no join (select de1.emp_no, s1.salary from dept_manager de1 join salaries s1 on de1.emp_no=s1.emp_no) managersalary#manager工资表 on manager...
