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

Chapter 10. Creating Multitable and Cros... > Outer, Self, and Theta Joins

Outer, Self, and Theta Joins

The preceding sections of this chapter described the equi-join or, in the parlance of SQL-92, an inner join. Inner joins are the most common type of join in database applications. Access also lets you create three other joins: outer, self, and theta. The following sections describe these three less common types of joins.

Creating Outer Joins

Outer joins allow you to display the fields of all records in a table participating in a query, regardless of whether corresponding records exist in the joined table. With Access, you can choose between left and right outer joins.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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