1、获取emp_no:SELECT emp_no
2、从employees和dept_manager左连接的表中获取:employees LEFT JOIN dept_manager ON employees.emp_no = dept_manager.emp_no
3、选取没有dept_no的行:WHERE dept_no IS NULL
4、串联:
SELECT emp_no
FROM employees
LEFT JOIN dept_manager ON employees.emp_no = dept_manager.emp_no
WHERE dept_no IS NULL