The LEFT JOIN keyword returns all records from the left table, with the matching records in the right table. The result is NULL in the right side when there is no match.