Listing Tables to Search with FROM
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.