Unfortunately, FULL OUTER JOIN does not work with traditional Oracle join syntax. You cannot do something like this : select e.last_name, e.first_name, t.task_name from employee e, task t where e.employee_id(+) = t.employee_id(+); You can only engage FULL OUTER JOIN with ANSI syntax like this : select e.last_name, e.first_name, t.task_name from employee […]