What does a LEFT JOIN return?

A Only rows that match in both tables B All rows from both tables regardless of matches C Only rows from the left table with no match in the right table D All rows from the left table and matching rows from the right table, with NULLs where there is no match