O'Reilly logo

Absolute Beginner’s Guide to Databases by John V. Petersen

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

Combine Multiple Tables: Use the Join Statement

Much of the time, you will want to extract data from multiple tables. For example, you might get a request to create a list of business clients and their associated contacts. This is the basic framework that will be used to introduce the concepts of joining tables. There are four types of joins: inner, left outer, right outer, and full outer. Figure 8.17 provides a graphical illustration of how the various types of joins work together in relation to the tables that are joined. Throughout this discussion, you will continually be referred to Figure 8.17. To illustrate how the different join techniques work, the Client and Contact tables will be used.

Figure 8.17. There are four ways two tables ...

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