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

where not