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

Chapter 10. Creating Multitable and Cros... > Introducing Joins on Tables

Introducing Joins on Tables

Your purpose in acquiring Access is undoubtedly to take advantage of its relational database management capabilities. To do so, you must be able to link related tables based on key fields that have values in common—a process known as a join in database terms. Chapter 8, "Designing Access Queries," and Chapter 9, "Understanding Query Operators and Expressions," showed you how to create simple queries based on a single table. If you tried the examples in Chapter 9, you saw a glimpse of a multiple-table query when you joined the Order Details table to the Orders table that you then joined to the Customers table to create the query for testing expressions. The first part of this chapter deals exclusively with queries created from multiple tables that are related through joins.

This chapter provides examples of queries that use each of the four basic types of joins that you can create in Access's Query Design view: equi-joins, outer joins, self-joins, and theta joins. Note, however, the two types of queries that you can't create in Access's Query Design window: UNION queries and subqueries based on tables. To create these types of queries, you must write SQL statements—the subject of Chapter 23, "Working with Structured Query Language."


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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