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 ...