What type of join includes all records from the left data set and matched records from the right data set?

The type of join that includes all records from the left data set and matched records from the right data set is known as a Left Join. In this scenario, a Left Join returns every row from the left table, ensuring that all of its data is preserved even when there are no corresponding matches in the right table. If a match exists in the right table, the result will also include the columns from that table; if no match is found, the result will return null values for those columns from the right table.

This behavior allows analysts to retain important data from the left dataset while also incorporating relevant information from the right dataset when it exists. This is particularly useful in scenarios where preserving the integrity of the left dataset is crucial, and you want to augment it with additional information where available.