select de.emp_no,dm.emp_no as manager
from dept_emp de inner join dept_manager dm
on de.dept_no = dm.dept_no
where de.emp_no != dm.emp_no;