98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Join queries - position of tables
Join queries - position of tables
Resolved · High Priority · Version 2003
Tue 23 Feb 2010, 11:00Delegate 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:45Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Pop up propertyIf 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. |
