best training access course - Queries

Hi Alex

Thank you for your question.

Firstly, it helps to understand the purpose of a join. A join is a temporary relationship that can be created between two tables that are included in a query, that are not related to each other through a relationship you have created or through a common field.

Creating an inner join within a query will result in Access selecting only the records from both of the tables that contain matching values within the joined field/s.

I hope this helps.
Amanda