This is the product description text that will appear here.
Quantity
1
Description
LEFT JOIN returns every row from the left table, matched with the right where a match exists and filled with NULL where it doesn't.
The distinction from INNER JOIN is the whole point: it keeps the rows that didn't match instead of silently ...