题解 | #获取所有非manager员工当前的薪水情况#
获取所有非manager员工当前的薪水情况
http://www.nowcoder.com/practice/8fe212a6c71b42de9c15c56ce354bebe
1. yong # select d1.dept_no, e.emp_no, s.salary # from employees as e, dept_manager as d1, salaries as s, dept_emp as d2 # where e.emp_no = d2.emp_no # and e.emp_no != d1.emp_no # and e.emp_no = s.emp_no # and d2.dept_no = d1.dept_no #先找到所有非manager员工emp_no,再内连接工资表和部门表即可 select de.dept_no,a.emp_no,s.salary from (select emp_no from employees where emp_no not in (select emp_no from dept_manager) ) a inner join dept_emp de on a.emp_no=de.emp_no inner join salaries s on a.emp_no=s.emp_no