>I think my post was correct. The KB article you reference indicates that
>filter conditions affecting the right side of a LEFT JOIN clause should go in
>the JOIN condition. Which is true. But the SQL that Randall posted included
>filter conditions affecting the left side. Those have no business being in the
>JOIN clause.

Arguably correct.