Notice in the diagram, that the LEFT JOIN selects the entire left table, plus the matching rows from the right table.