CROSS JOIN

Back to Joins

Returns the Cartesian product of two tables, combining every row from the first table with every row from the second.

relational-databases sql joins