SELECT a.emp_no,b.emp_no manager_no,a.salary emp_salary,b.salary manager_salaryFROM (SELECT de.emp_no,s1.salary,de.dept_no FROM dept_emp de,salaries s1 WHERE de.emp_no=s1.emp_no) a, (SELECT dm.emp_no,s2.salary,dm.dept_no FROM dept_manager dm,salaries s2 WHERE dm.emp_no=s2....
投递咪咕等公司8个岗位