2 ms·
I was taught the second style of joins in the WHERE clause, but moved to the first style as I saw it was recommended. Having used both, the INNER JOIN style ma
by collyw 10y ago
I was taught the second style of joins in the WHERE clause, but moved to the first style as I saw it was recommended.
Having used both, the INNER JOIN style makes more sense to me, as you are describing the JOINS when you are adding the tables and keeps it separate from the WHERE clause which is really a filtering step.
The second style combines the two and makes and makes it less clear what you are trying to achieve in my opinion.