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