Join queries - position of tables

Resolved · High Priority · Version 2003

Tue 23 Feb 2010, 11:00 Delegate Kerina said...

Kerina has attended:
Access Advanced course

Join queries - position of tables

Hi there,

When runinng join queries it seems that the sequence of tables used matters greatly. For example if the there are more entries in table 2 than table 1, and you insert table 1into the query first, then the entries of table 1 will only be shown.
Why are join queries so sensitive to order of table insertion?

Thanks
Kerina

Wed 24 Feb 2010, 09:45 Trainer Stephen said...

RE: Join queries - position of tables

Hi Kerina

Thank you for your question

It is indeed the case that the sequence of tables matters in terms of the results that you receive from your query. The default position is that only records that appear in both tables will be displayed, and this is known as an "inner join". It is possible to show all records in the left hand table and matching records in the right, or vice versa; these are respectivley a "Left Outer Join" and a "Right Outer Join".

To change these settings,double click on the link between the two tables, and in the resulting dialog box select the required option.

Regards

Stephen

Tue 2 Mar 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips