# 两个表: # 1.员工薪水部门表 # 2.经理薪水部门表 # 3.两个表根据部门链接 # 4.筛选出员工薪水>经理薪水的记录 select t1.emp_no,t2.manager_no,t1.salary,t2.salary from (select d.emp_no,salary,dept_no from dept_emp d,salaries s where d.emp_no=s.emp_no) as t1, -- 员工薪水部门表 (select dp.emp_no manager_no,salary,dept_no from ...