In Query, default type of join between two tables where only the records that have the same values in the joined fields are selected. The two matching records from each table are combined and displayed as one record in the result set.