O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

When diagramming database structures (a subject of Chapter 22, "Exploring Relational Database Design and Implementation"), you traditionally would draw ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required