select emp_no , (select emp_no from dept_manager dm where dm.dept_no = de.dept_no) as manager
from dept_emp de where not exists (select 1 from dept_manager dep where
                                  dep.emp_no = de.emp_no)