As Cindy says, WHERE is equivalent to an INNER JOIN. In 2.x, we didn't have the INNER JOIN syntax, and had to use WHERE for both JOINS and filter conditions. Now that we have both, I prefer to use INNER JOIN for joins, and WHERE for filter conditions, so they're not mixed together in the same clause. It makes things easier to read.