SQL joins never match NULL to NULL. pandas merge does, which attaches unrelated rows. Remove missing keys from the lookup side before merging in pandas.
- Lesson: Joins where missing keys never match
- Practise: Join orders to customers without matching blanks
Related: Referential integrity, Missing value (null)