For two tables that have a(n) _____ join, a query will select all the records in the "one" table even if they do not have matching records in the "many" table.

A) inner
B) self
C) right outer
D) left outer

A left outer join selects all records from the "one" table and matching records from the "many" table. However, if there are no matching records in the "many" table, the selected rows will still be included in the final result set with NULL values for the columns from the "many" table.