Forum home » Delegate support and help forum » Microsoft Access Training and help » best training access course - Queries
best training access course - Queries
Resolved · Low Priority · Version Standard
Alexandra has attended:
Access Intermediate course
Queries
Please explain the Inner joins?
Many thanks,
Alex
For upcoming training course dates see: Pricing & availability
RE: 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
|
