• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Changing Joins

By default, when you create a relationship between two tables, Access creates what database experts call an inner join—if you create a query based on those two tables, the result shows only those records that match in both tables. In some cases, however, you may want a query to include information about all records in one table—regardless of whether a correspond-ing record is currently in another related table. For example, if you're using the query to generate a report of all orders over the past quarter, you may be especially interested in seeing the records of people in your Customers table who didn't place an order during that time. To do so, you need to change the query's join type.

You can use the Relationships window to adjust join types for the default relationship between tables, but this option is usually better performed on a specific query, where you can control its effects. In the database window, select the query you want to modify, and then click the Design button to switch into Design view. In the upper section of the resulting Design window, you see field lists for the related tables on which the query is based; in the lower section, you see the specific fields that you've selected for the query. To change the join type, double-click the line between the two tables, or choose View, Join Properties.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint