|
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.
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];