FROM Clause (SQL Only)

See AlsovbhowSQLFROMSee                 ExamplevbhowSQLSELECTEx>Low

Description

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

Notes

         FROM is required and follows SELECT.

         The order of the table names is not important.

         Data may be retreived from external databases if the table is attached to your database. If you wish to retrieve data from an external table that is not attached, you will need to use the IN clause with the FROM clause.

         The following example shows how you can retrieve data from a table of Titles:

  SELECT *  FROM Titles