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