A join in which rows from two tables are combined and added to the result set when there are equal values in the joined columns. By default, the inner and outer join types in the Query Designer are equijoins.

A join statement that uses an equivalency operation. The converse of this is the nonequijoin operation.

A join of two columns with the equal operator, dictating that only those rows that have identical data in the defined columns on opposite sides of the operator will be joined.