( 7 months ago )
INNER JOIN is ANSI syntax which you should use.
It is generally considered more readable, especially when you join lots of tables.
It can also be easily replaced with an
OUTER JOIN whenever a need arises.
WHERE syntax is more relational model oriented.
A result of two tables
JOINed is a cartesian product of the tables to which a filter is applied which selects only those rows with joining columns matching.
It's easier to see this with the
As for your example, in MySQL (and in SQL generally) these two queries are synonyms.
Also note that MySQL also has a
Using this clause, you can control the
JOIN order: which table is scanned in the outer loop and which one is in the inner loop.
You cannot control this in MySQL using