SELECT *FROM employeesWHERE not EXISTS( select emp_no from dept_emp where employees.emp_no=dept_emp.emp_no);