select s.emp_no, b.emp_no as manager_no, s.salary as emp_salary, b.salary as manager_salary from dept_emp as de inner join salaries as s on de.emp_no = s.emp_no # 员工薪水表 inner join( select # 经理薪水表 dept_no, s.emp_no, salary from dept_manager as dm inner join salaries as s on dm.emp_no = s.emp_no ) as ...