CROSS JOIN has no ON: it pairs every row of the first table with every row of the second. 4 trainers × 5 gyms = 20 combinations:
↗️
Loading editor...
↶
↷
Most of the time this is not what you want — but it is perfect to build a grid of possibilities: every challenge a trainer could attempt.
The accidental cross join
Remember: an INNER JOIN whose ON you forgot behaves exactly like a CROSS JOIN. If a result suddenly has far too many rows, check your join conditions first.