Listing Tables to Search with FROM

From InterBase
Jump to: navigation, search

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.