Lesson 5.7 · Pro
CROSS JOIN: every combination
Build a full grid (every day × every city) so missing combinations show up as 0.
In this lesson
- Every row paired with every row
- Fill the grid with LEFT JOIN
- Accidental cross joins
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.