Microsoft Access Database Development With VBA

SQL Keywords: FROM

   

Description

The FROM keyword is used to specify the name of the table or query of a SELECT statement. The primary formula to follow is:

SELECT What FROM WhatObject;

The What factor of our syntax can be the name of a column of a table or query. The WhatObject factor can be the name of a table or a query.

Examples

Here is an example that selects one field from a table:

SELECT LastName FROM Employees;

Here is an example that selects all fields from a table:

SELECT * FROM Employees;

Here is another example:

SELECT [Employees].[FirstName], [Employees].[LastName]
FROM [Employees];

See Also

 

 

 
 
     
 

Home Copyright © 2012 FunctionX, Inc. Home