Which type of database JOIN returns all records from the left table and matching records from the right table, filling with NULL where no match exists?

Explanation

A LEFT JOIN (or LEFT OUTER JOIN) fetches every record from the left table. If a row has no corresponding match in the right table, SQL returns NULL for all right-table columns.