The Hidden Power (and Risk) of MySQL CROSS JOIN

Most JOINs filter and refine. A MySQL CROSS JOIN does the opposite. It produces a Cartesian product, generating every possible row combination between two tables. That makes it ideal for modeling permutations, scheduling, or building complete matrice...