a data join based on equality comparisons between common columns of two or more tables

a JOIN operations that allows you to specify an explicit join clause

an operation that combines rows from two tables by matching the values in a column in one table to the values of a corresponding column in the other table

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 certain specified criteria. For example, the default join between tables in Query Designer view is an inner join that selects records from both tables only when the values of the joined fields are equal. Compare with outer join.

The INNER JOIN returns all the rows from two related tables where there is a match in a common field.

(SQL) Join of two tables with join attributes specified by the programmer. jointypes.php

an SQL query operation that results in only those records for which the linking entity is found in all joined tables

A join in which rows appear in the result set only if both tables satisfy the join condition. Inner joins are the default. See also: join, outer join.

In an Access query, the link between two related tables, that only returns related fields that are common in both tables.

See Equi Join.