select t2.dept_no,t1.emp_no,t1.salary from (select a.emp_no,d.salary,a.first_name from employees a join salaries d on a.emp_no=d.emp_no) t1 join (select b.emp_no,b.dept_no from dept_emp b) t2 on t1.emp_no=t2.emp_no where t1.emp_no not in (select emp_no from dept_manager) 主要是分辨出非manager...