Initializing...

Chapter 7: Advanced Joins

7-1

Your Progress

Progress

0/22 lessons

Completed

lessons done

Chapters

completed

Streak

days

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.

Run a query to see results