CROSS JOIN
Learn CROSS JOIN (Joins, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A CROSS JOIN returns the Cartesian product : every row of the first table paired with every row of the second (n x m rows), with no join condition.