题解 | 获取所有非manager员工当前的薪水情况
select dt.dept_no,e.emp_no,s.salary from employees e left join dept_emp dt on e.emp_no=dt.emp_no left join salaries s on e.emp_no=s.emp_no where e.emp_no not in(select dp.emp_no from dept_manager dp)
select dt.dept_no,e.emp_no,s.salary from employees e left join dept_emp dt on e.emp_no=dt.emp_no left join salaries s on e.emp_no=s.emp_no where e.emp_no not in(select dp.emp_no from dept_manager dp)
相关推荐