** 简单思路 **

select de.emp_no, dm.emp_no as manager
from dept_emp as de inner join dept_manager as dm
on de.dept_no = dm.dept_no and de.emp_no not in (select emp_no from dept_manager)