两种写法

select emp_no
from employees
where emp_no not in(
    select emp_no
    from dept_manager
)

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