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
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
