Querying from Multiple Tables
Grant Allen, Bob Bryla, Darl Kuhn · Apress eBooks · 2009
Querying data from Oracle tables is probably the most common task you will perform as a developer or data analyst, and maybe even as a DBA — though probably not as the ETL (Extraction, Transformation, and Loading) tool expert. Quite often, you may query only one table for a small subset of rows, but sooner or later you will have to join multiple tables together. That’s the beauty of a relational database, where the access paths to the data are not fixed: you can join tables that have common columns, or even tables that do not have common columns (at your own peril!). These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.