CROSS JOIN
A CROSS JOIN returns the Cartesian product of two tables - meaning it combines every row from the first table with every row from the second table.
SELECT * FROM colors CROSS JOIN sizes;
If table A has 3 rows and table B has 4 rows, the result will have 3 x 4 = 12 rows.
Task:
Generate all possible combinations of shirts and pants.