Lesson 5.1 · Pro
INNER JOIN: combine matching rows
Bring columns from two or more tables together by matching their keys.
In this lesson
- Match rows on a key
- Join, then group
- Join on two columns
- Count a subset after joining
- Group by a column you don't show
- Join three tables
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.