Lesson 5.3 · Pro
LEFT JOIN: ON or WHERE?
The same condition gives different results in ON and in WHERE. Learn which one you need.
In this lesson
- A filter on the left table goes in WHERE
- A condition on the right table goes in ON
- Two conditions in ON
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.