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 not in (
    select emp_no from dept_manager
)