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
Understanding the principles of joining tables
So far, we have seen several ways to select data from tables. ...