best training access course

best training access course - Queries

Resolved · Low Priority · Version Standard

Queries

Alexandra has attended:
Access Intermediate course

by - delegate Alexandra [1 post] (2007 Oct 23 Tue, 13:51) Reply

Please explain the Inner joins?
Many thanks,
Alex

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Queries

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 23 Tue, 14:25) Reply

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