October 1997
Intermediate to advanced
1312 pages
38h 56m
English
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.
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 ...
Read now
Unlock full access