Chapter 5. Combining Data from Multiple Tables

The ability to retrieve data from a table is an absolutely essential element of learning SQL. However, real-world requirements often demand the ability to select data from multiple tables concurrently and present it in a meaningful way. Herein lies the ability to join tables. This chapter will cover two distinct syntaxes for joins as well as multiple techniques for combining data from multiple tables.

In this chapter, we shall:

  • Examine the concept of joining multiple tables together
  • Join tables using ANSI-compliant join syntax
  • Look at n-1 join conditions
  • Join tables using the new Oracle join syntax

Understanding the principles of joining tables

So far, we have seen several ways to select data from tables. ...

Get OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.