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