<< Click to Display Table of Contents >> Navigation:  Local SQL > Data Manipulation Language > Clauses > FROM clause

Specifies the tables from which a SELECT statement retrieves data.

FROM table_reference [, table_reference...]

Description

Use a FROM clause to specify the table or tables from which a SELECT statement retrieves data. The value for a FROM clause is a comma-separated list of table names. Specified table names must follow local SQL naming conventions for tables. In statements that support the FROM clause, the clause is required.

In the following example of a SELECT statement, a single Paradox table is specified in the statement’s FROM clause.

SELECT *

FROM "Customer.db"

Define table correlation names for tables in the FROM clause. These table correlation names can then be used elsewhere in the statement. In the SELECT statement below, the table correlation name Res is defined for the table RERSERVAT.DB:

SELECT Res.ResNo, Res.Amt_Paid

FROM "Reservat.db" Res

WHERE (Res.Pay_Method = "VISA")

See the section Relational Operators for more information on retrieving data from multiple tables in a single SELECT query.

Local SQL also supports retrieving data from saved queries (SQL or QBE) by specifying the saved file in the FROM clause of a statement. See local SQLVIEW for more information on this.

Applicability

SELECT statements