SQL Keywords: FROM

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

• AS
• ASC
• BY
• DESC
• ORDER
• WHERE