This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

inner join

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, when designing a query, the default join between tables is an inner join that selects records from both tables only if the values of the joined fields are equal.