FROM Clause (Microsoft Jet SQL)

FROM Clause

Specifies the tables or queries that contain the fields listed in the SELECT statement.

Syntax

SELECT fieldlist
    FROM tableexpression [IN externaldatabase]

A SELECT statement containing a FROM clause has these parts:

Part	Description
fieldlist	The name of the field or fields to be retrieved along with any field-name aliases, SQL aggregate functions, selection predicates (ALL, DISTINCT, DISTINCTROW, or TOP), or other SELECT statement options.
tableexpression	An expression that identifies one or more tables from which data is retrieved. The expression can be a single table name, a saved query name, or a compound resulting from an INNER JOIN, LEFT JOIN, or RIGHT JOIN.
externaldatabase	The full path of an external database containing all the tables in tableexpression.

Remarks

FROM is required and follows any SELECT statement.

The order of the table names in tableexpression is not important.

For improved performance and ease of use, it is recommended that you use a linked table instead of an IN clause to retrieve data from an external database.

The following example shows how you can retrieve data from the Employees table:

SELECT LastName, FirstName

FROM Employees;

See Also

ALL DISTINCT, DISTINCTROW, TOP Predicates (Microsoft Jet SQL)	SELECT Statement (Microsoft Jet SQL)
IN Clause (Microsoft Jet SQL)	SQL Aggregate Functions (SQL)
LEFT JOIN, RIGHT JOIN Operations (Microsoft Jet SQL)	WHERE Clause (Microsoft Jet SQL)
INNER JOIN Operation (Microsoft Jet SQL)

Example

SELECT Statement, FROM Clause Example