建立员工表(除经理),建立经理表,再用部门编号将两表连接为一个,最后用条件筛选 select yuangong.emp_no as emp_no, manager.emp_no as manager_no, yuangong.salary as emp_salary, manager.salary as manager_salary from ###员工的部门编号,员工号,员工薪水选出来建立新表yuangong (select a.dept_no,a.emp_no,s.salary from ###选出员工表里不是经理的 (select de.emp_no,de.dept_no from...