Can an Oracle pl/sql expert help me construct a left outer join in Oracle 9i that excludes some values in the join table?
Select a.emp, b.manager from emp a, manager b
where a.empid = b.empid(+)
and b.managerID <> '123';
How do I retrieve all employee info and all manager info except for managerid '123' in one query. The query above cancels out the outer join and limits the results to only the manager table.