You should avoid using old outer join syntax with +, use the ANSI compliant syntax of OUTER JOIN to avoid unexpected results.