• 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 equi-join or, in the parlance of SQL-92, an inner join. Inner joins are 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