O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

10

Joining Tables

In this chapter:

  • What is a join?

  • What is Oracle’s proprietary format for joins?

  • What is the ANSI join format?

  • What types of joins can be performed?

  • How can joins be implemented?

A join is retrieval of data from more than one table. This chapter shows you how to merge rows from multiple tables into a single query. Merging of rows is known as a join. This chapter experiments with example SELECT statements containing many different types of joins.

In previous chapters you have explored the SELECT, FROM, WHERE, and ORDER BY clauses. Both the American National Standards Institute (ANSI) format JOIN clause and the Oracle proprietary format for joining tables are used in all examples where possible. The JOIN clause is the ANSI equivalent ...

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