SELECT e.* FROM employees e WHERE NOT EXISTS ( SELECT 0 FROM dept_emp d WHERE e.emp_no = d.emp_no );