The FROM clause: Specifying tables

The FROM clause is required in every SELECT statement involving data from tables, views, or stored procedures.

The FROM clause can include JOIN conditions linking two or more tables, and can include joins to other queries (derived tables).

 Qualifying table names
 Using correlation names
 Querying derived tables
 Querying objects other than tables
 See also

SELECT over a DML statement