FROM salaries a
JOIN dept_emp b
ON a.emp_no=b.emp_no
WHERE a.emp_no NOT IN
(
SELECT emp_no FROM dept_manager
)