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

Hour 10. Creating Queries > Building Queries Based on Multiple Tables

Building Queries Based on Multiple Tables

If you have properly normalized your table data, you probably want to bring the data from your tables back together by using queries. Fortunately, you can do this quite easily by using Access queries.

The query in Figure 10.10 joins the Customers, Orders, and Order Details tables, pulling fields from each. Notice in the figure that I have selected the CustomerID and CompanyName fields from the Customers table, the OrderID and OrderDate fields from the Orders table, and the UnitPrice and Quantity fields from the Order Details table. After you run this query, you should see the results shown in Figure 10.11. Notice that you get a record in the query's result for every record in the Order Details table. In other words, there are 2,155 records in the Order Details table, and that's how many records appear in the query output. By creating a multitable query, you can look at data from related tables, along with the data from the Order Details table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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