Lesson 5.2 · Pro
LEFT JOIN: keep every row
Keep all rows from the first table, even the ones with no match, and handle the NULLs that creates.
In this lesson
- Keep every row from the left table
- COUNT(*) counts the empty matches too
- Use the NULLs to measure coverage
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.