• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Creating Multitable and Cros... > Joining Tables to Create Multitable ...

Joining Tables to Create Multitable Queries

Before you can create joins between tables, you must know which fields are related by common values. As mentioned in Chapter 4, assigning identical names to primary- and foreign-key fields in different tables that contain related data is a common practice. This approach, used by Microsoft when creating the Northwind sample database, makes determining relationships and creating joins among tables easier. The CustomerID field in the Customers table and the CustomerID field in the Orders table, for example, are used to join orders with customers.

Figure 10.1 shows the structure of the Northwind database with a graphical display of the joins between the tables. Access query designs indicate joins with lines between field names of different tables. Bold type indicates primary-key fields. Each join usually involves at least one primary-key field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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