Chapter 5 · Lesson 3 of 5

03. LEFT JOIN: keeping rows with no match

LEFT JOIN keeps every row of the first table, even with no match. IS NULL then finds the ones with nothing.