A join in which records from two tables are combined and added to the result set only when there are equal values in the joined fields. The inner and outer join types you use in query Design view are equi-joins. In SQL view, however, you can create joins that aren't equi-joins, but select records when the value in one join field is >, <, <>, >=, or <= the value in the other join field.