select * from employees e where not exists( select emp_no from dept_emp d where e.emp_no = d.emp_no );