select de.emp_no, dm.emp_no as manager
from dept_emp de 
join dept_manager dm using (dept_no)
where de.emp_no <> dm.emp_no