Home

SQL Keywords: FROM

  

Introduction

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 © 2009-2010 FunctionX