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

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

Outer, Self, and Theta Joins

The preceding sections of this chapter described the inner join, which is the most common type of join in database applications. Jet also lets you create three other joins: outer, self, and theta. The following sections describe these three less-common types of joins, which also apply to SQL Server views, functions, and stored procedures.

Creating Outer Joins

Outer joins let you display the fields of all records in a table participating in a query, regardless of whether corresponding records exist in the joined table. Jet lets you 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