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 | 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 | 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 | 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, 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;