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排除是经理的员工