select d.dept_no,e.emp_no,s.salary from employees as e inner join salaries as s on e.emp_no = s.emp_no inner join dept_emp as d on d.emp_no = e.emp_no where e.emp_no not in (select emp_no from dept_manager)
联表查询后用not in排除是经理的员工
select d.dept_no,e.emp_no,s.salary from employees as e inner join salaries as s on e.emp_no = s.emp_no inner join dept_emp as d on d.emp_no = e.emp_no where e.emp_no not in (select emp_no from dept_manager)
联表查询后用not in排除是经理的员工