Relationships

Hi Helena

The definition of an Inner Join is:

A join that selects only those records from both database tables that have matching values.

Records with values in the joined field that do not appear in both of the database tables will be excluded from the query. One or more fields can serve as the join fields.

For example an Inner join on the Customers and Order tables will only show Customers with Orders and leave out any customers without Orders or Orders without Customers.

The inner join is also known as an equi-join.

The inner join is the default join type in Microsoft Access.

Hope this helps

Carlos