左连接，然后dept_no 为null的则是非manager

select employees.emp_no
from  employees
left join dept_manager
on employees.emp_no=dept_manager.emp_no
where dept_manager.dept_no is null