题解 | #获取所有非manager员工当前的薪水情况#

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