FROM clause
The part of a SELECT that names the table, or joined tables, the rows come from.
In more detail
Joins are written inside the FROM clause, and a subquery can stand in for a table there. Logically the FROM clause is evaluated first, before any filtering.
Related terms
- SELECT — The SQL statement that reads data: it names the columns you want in the answer and, with FROM, the tables they come from.
- join — Combining rows from two tables into one result by pairing rows according to a rule, usually matching keys.
- table alias — A short name given to a table inside one query, such as c for customers, used to qualify its columns.
Taught in
- Thirty Eight Percent More: Billing Models And Tags — CompTIA Cloud+ (CV0-004) Exam Prep
- An Image That Runs As Root: Security Best Practices — CompTIA Cloud+ (CV0-004) Exam Prep
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling
- Inner Joins And Table Aliases — PostgreSQL, Indexing & Relational Data Modeling