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

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

Introducing Joins on Tables

Your purpose in acquiring a license for 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 called joining tables. Chapter 9, “Designing Queries for Jet Databases,” and Chapter 10, “Understanding Jet Operators and Expressions,” showed you how to create simple queries based on a single table. If you tried the examples in Chapter 10, you generated a multiple-table query when you joined the Order Details table to the Orders table and 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: inner joins, outer joins, self-joins, and theta joins. It also shows you how to take advantage of UNION queries that you can’t create in Access’s Query Design. The chapter also briefly covers subqueries, which you can substitute for nested Jet queries. Chapter 13, “Creating and Updating Jet Tables with Action Queries,” presents typical applications for and examples of four types of action queries: update, append, delete, and make-table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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