Sign in
Oracle's Joins
Book chapter

Oracle's Joins

Richard Earp and Sikha S Bagui
Oracle Internals: Tips, Tricks, and Techniques for DBAs, pp.643-650
Auerbach Publishers, Incorporated, 1st
2001

Metrics

20 Record Views

Abstract

There is often a need to select data from columns from more than one table. A join combines columns and data from two or more tables (and in some cases, of one table with itself). The tables are listed in a FROM clause of a SELECT statement, and a join condition between the two tables is specified in a WHERE clause.

Details

Logo image