This chapter describes joins of tables and views.
The chapter also presents an outer join case study (see “Outer Join Case Study” on page 264) that shows how to write correct outer joins that behave the way you intend.
For information on the algorithms used by the Optimizer to perform these joins, see Chapters 3 and 4 of SQL Request and Transaction Processing.