题解 | #获取所有非manager员工当前的薪水情况#

select de.dept_no,s.emp_no,s.salary from employees as e
inner join dept_emp as de on e.emp_no = de.emp_no
inner join salaries as s on de.emp_no = s.emp_no
where de.emp_no not in(select emp_no from dept_manager)

知识点:

1. 表链接
2. not in (不包含）
3. 子查询