This is the way OUTER JOIN works. Adding the condition in the WHERE clause
effectively turns the OUTER JOIN to INNER JOIN. Keeping all conditions in
the JOIN clause preserves the outer rows. Since the outer rows have NULL
value for the attribute adding a filter in WHERE removes all outer rows.
HTH,
Plamen Ratchev
effectively turns the OUTER JOIN to INNER JOIN. Keeping all conditions in
the JOIN clause preserves the outer rows. Since the outer rows have NULL
value for the attribute adding a filter in WHERE removes all outer rows.
HTH,
Plamen Ratchev
