O'Reilly logo

Oracle® SQL by Example, Fourth Edition by Alice Rischert

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

Chapter 7. Equijoins

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

In this lab, you will join ...

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