#使用inner join 排除了没有工资的员工和没有分配部门的员工。
select de.dept_no,s.emp_no,salaries.salary
from
(select e.emp_no
from employees e
where e.emp_no not in (select emp_no from dept_manager)) as s inner join dept_emp de on s.emp_no==de.emp_no
inner join salaries on s.emp_no==salaries.emp_no