select a.emp_no, b.emp_no as manager
from dept_emp a join dept_manager b
on a.dept_no=b.dept_no and a.emp_no<>b.emp_no