select e.emp_no as emp_no, d.emp_no as manager from dept_emp e left join dept_manager d on e.dept_no = d.dept_no where e.emp_no != d.emp_no; # where e.emp_no <> d.emp_no;