O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required