JOIN and comma precedence

Here’s a little something that might trip you up occasionally. Have a look at this test scenario:

Q1 and Q2 will produce the same result, right? Wrong! As of MySQL 5.0.12, per the SQL standard, JOIN has had higher precedence than comma ‘,’. So, you get the following:

This is because, in earlier […]