Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Chapter 6. Combining Data Tables > 6.3 Joining Tables

6.3 Joining Tables

When you append tables, you match columns. But often, instead of matching columns, you need to match rows. For example, a teacher might record grades from homework in one table and grades from tests in another. To compute final grades she would need to match the homework and test scores for each student. This is called joining tables, and you do it with a query.

In the preceding section, two tables were appended to create one table containing all the data about flights. Now the data for each tour can be joined with the matching data for flights. To open the Query Builder, click a data icon in the Project Tree or Process Flow, and select Tasks Data Query Builder from the menu bar.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint