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