This chapter describes database queries that look at information in more than one table. To do this, SQL provides the JOIN operator. There are several different ways to join tables together in queries, and this chapter describes some of the more important ones.
Introduction
Joining tables using the cross product
Using the ON phrase to restrict a join
Joining tables using key joins
Joining tables using natural joins
Joining tables using outer joins