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

3

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