select b.emp_no,a.emp_no manager_no,b.salary emp_salary,a.salary manager_salary from (select d.dept_no,d.emp_no,s.salary from dept_manager d join salaries s on d.emp_no=s.emp_no)a //领导工资表 join (select d.dept_no,d.emp_no,s.salary from dept_emp d join salaries s on d.emp_no=s.emp_no)b //员工工资表 on a.dept_no=b.dept_no where b.salary>a.salary;