select d.dept_no,s.emp_no,s.salary  from dept_emp d
join salaries s on d.emp_no=s.emp_no
where d.to_date='9999-01-01' and 
s.emp_no not in (select emp_no from dept_manager)