Orderfieldlist

This clause of the SELECT statement defines the fields that are returned by the query.

Syntax:

  [table.|alias.]field1 [AS fieldalias1]
  [, [table.|alias.]field2 [AS fieldalias2][, ...]]

The parts of this clause have the following meaning:

Part Meaning

table The table from which the data is retrieved

alias An alias, defined in the SELECT statement's tablespec clause

field1, field2 The fields containing the required data

fieldalias1, fieldalias2 The column heading for the returned row

[Return to SQL Syntax]

Part	Meaning
table	The table from which the data is retrieved
alias	An alias, defined in the SELECT statement's tablespec clause
field1, field2	The fields containing the required data
fieldalias1, fieldalias2	The column heading for the returned row