Listing Tables to Search with FROM
Go Up to Understanding Data Retrieval with SELECT
The FROM
clause is required in a SELECT
statement. It identifies the tables, views, or select procedures from which data is to be retrieved. The complete syntax of the FROM
clause is:
FROM table | view | procedure [alias] [, table | view | procedure [alias] ...]
There must be at least one table, view, or select procedure name following the FROM keyword. When retrieving data from multiple sources, each source must be listed, assigned an alias, and separated from the next with a comma. For more information about select procedures, see Working with Stored Procedures.