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.
Related links
Details
Title
Oracle's Joins
Edition
1st
Publication Details
Oracle Internals: Tips, Tricks, and Techniques for DBAs, pp.643-650