SELECT e.emp_no FROM employees AS e LEFT JOIN dept_manager AS dept ON e.emp_no=dept.emp_no WHERE e.emp_no NOT IN (SELECT emp_no FROM dept_manager )

SELECT e.emp_no FROM employees AS e LEFT JOIN dept_manager AS dept ON e.emp_no=dept.emp_no WHERE e.emp_no NOT IN (SELECT emp_no FROM dept_manager )