Commonly Used SQL Clauses
The following list describes the SQL clauses that you will use most frequently. In relation to the previous SQL statements, the WHERE clause is used with the DELETE, UPDATE, and SELECT statements; the remaining clauses are only used with the SELECT statement.
FROM
FROM table_name [,...]
Description:
The FROM clause specifies the tables from which a statement should retrieve data. You can combine the FROM clause with AS to assign aliases to table names. For example, to assign an alias of products to a table called us_products, you use the following syntax:
FROM us_products AS products.
WHERE
WHERE Boolean_expression
Description:
The WHERE clause restricts a statement so that it only returns those rows or records ...
Get Sams Teach Yourself J2EE™ in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.