A FROM clause identifies the table or tables that supply the rows for an SQL query. It answers the question, “Where should the data come from?” section 1.5
Choose products as the source
In SELECT name FROM product WHERE price > 20;, FROM product tells the RDBMS to retrieve rows from the product table. SELECT chooses the name column, while WHERE keeps products priced above 20. section 1.5
Use the FROM clause with other clauses to shape a query:
- SELECT chooses the columns to retrieve. section 1.5
- FROM identifies the source table or tables. section 1.5
- WHERE filters the retrieved rows by condition. section 1.5
SELECT name FROM product WHERE price > 20;
View the complete three-clause query showing FROM in context. section 1.5
