Do WHERE statements filter the pre-join tables or the after-join table?

[yosiasz]

What research have you done so far. I think it Has already been answered for you.

What is the difference between ON C1=C2 AND C3=C4 and ON (C1=C2 AND C3=C4)?

You've been asking lots of questions involving operator precedence. You may find this useful.