Oracle SQL By Example

Chapter 7. Equijoins

Chapter Objectives

In this chapter, you will learn about:

• The Two-Table Join

• Joining Three or More Tables

So far, you have written SQL statements against a single table. In this chapter, you will learn about joining tables, one of the most important aspects of the SQL language. The equijoin, which is by far the most common form of join, allows you to connect two or more tables. Equijoins are based on equality of values in one or more columns. You will learn about other types of joins in Chapter 10, “Complex Joins.”

Lab 7.1 The Two-Table Join

Lab Objectives

After this lab, you will be able to:

• Write Simple Join Constructs

• Narrow Down Your Result Set

• Understand the Cartesian Product

In this lab, you will join ...