A join in which records from two tables are combined and added to a query's results only if the values of the joined fields meet a specified condition. For example, the default join between tables in query Design view is an inner join that selects records from both tables only when the values of the joined fields are equal.