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.