To get matching rows, but also keep the ones without a match from the first table, we use a LEFT JOIN.

Make sure to type LEFT JOIN.