【译文】如何使用Access SQL 检索记录(一)

时　间:2014-02-17 09:24:13
作　者:周芳   ID：24526  城市：上海
摘　要:如何使用Access SQL 检索记录
正　文:

来自：微软    翻译：周芳

【译文】 如何使用Access SQL 检索记录

      最基本、最常用的SQL语句是Select语句。Select语句是所有SQL语句的核心组成部分,而它们通常称为Select查询。使用Select语句从数据库表中检索数据,并且返回的结果通常是由任意数量的字段(或列)组成的一组记录（或行）。你必须使用FROM子句指定表或表来选择。Select语句的基本结构是:

VBA：
Select field list
    FROM table list

     要查询表中的所有字段,用星号(*)。例如,以下语句是从客户表中查询所有的字段和记录。

VBA：
Select *
    FROM tblCustomers

      限制查询检索的字段,只需使用字段名。例如：

VBA：
Select [Last Name], Phone
    FROM tblCustomers

      在结果集字段指定一个不同的名称,使用关键字建立该字段的别名。

VBA：
Select CustomerID AS [Customer Number]
    FROM tblCustomers

【原文】 How to: Retrieve Records Using Access SQL

      The most basic and most often used SQL statement is the Select statement. Select statements are the workhorses of all SQL statements, and they are commonly referred to as select queries. You use the Select statement to retrieve data from the database tables, and the results are usually returned in a set of records (or rows) made up of any number of fields (or columns). You must use the FROM clause to designate which table or tables to select from. The basic structure of a Select statement is:

VBA：
Select field list
    FROM table list

      To select all fields from a table, use an asterisk (*). For example, the following statement selects all the fields and all the records from the Customers table.

VBA：
Select *
    FROM tblCustomers 

      To limit the fields retrieved by the query, simply use the field names instead. For example.

VBA：
Select [Last Name], Phone
    FROM tblCustomers 

      To designate a different name for a field in the result set, use the AS keyword to establish an alias for that field.

VBA：
Select CustomerID AS [Customer Number]
    FROM tblCustomers