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