A join that includes all of the rows from the first table in the query and only those records from the second table that match the join field in the first table.