select * from employees
where not EXISTS (
select emp_no from dept_emp where employees.emp_no=dept_emp.emp_no)

exists的详细解释在：https://zhuanlan.zhihu.com/p/351922940