Subject Re: [firebird-support] filter conditions: WHERE vs. JOIN clause
Author W O
Hello Ann

Can you please explain better that phrase?

"With outer joins, a condition in the WHERE clause that affects the right side of a left outer join (the one that doesn't have to exist) effectively turns off the outerness of the join (unless it includes OR <value> IS NULL)."

Greetings.

Walter.