select d.emp_no,m.emp_no as manager
from dept_emp as d
left join dept_manager as m
on d.dept_no=m.dept_no
where d.emp_no!=m.emp_no