Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

The FROM Clause

The FROM clause is the second mandatory SELECT statement clause. It is used to identify the database objects that store the attributes that satisfy the statement. These attributes can exist in any of the statement’s various clauses. This clause is the second clause of the statement and begins with the keyword FROM. The clause follows the last expression in the SELECT clause and can contain the names of tables or views or another SELECT statement. In the examples seen thus far, the FROM clauses have contained only one table name. In the following section, you will see additional FROM clause functionality and options.

Retrieving Records from Multiple Tables

The true power of a relational database is its ability to combine records ...