A join in which the values in the columns being joined are compared for equality, and all columns are included in the results.