How can we get all left-table items plus any existing matches in the right table?

With a LEFT JOINWith a RIGHT JOIN

With a LEFT JOIN.