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

SELECT
	dept_emp.dept_no,
	employees.emp_no,
	salary 
FROM
	employees,
	dept_emp,
	salaries 
WHERE
	employees.emp_no NOT IN ( SELECT emp_no FROM dept_manager ) 
	AND employees.emp_no = dept_emp.emp_no 
	AND dept_emp.emp_no = salaries.emp_no