[AccessD] Field aliases

Steve,

You can alias the table or an expression or field using AS.  You can
even alias an in-line subquery that way.

Charlotte Foust

-----Original Message-----
From: Steven W. Erbach [mailto:serbach at uswest.net] 
Sent: Tuesday, June 10, 2003 11:04 AM
Subject: [AccessD] Field aliases


Dear Group,

SQL has always had the AS keyword to allow the assignment of an alias to
a table name. Is there such a thing as an alias for a field name?
Something
like:

  SELECT A.[Really Long Field Name 1] AS F1,
  A.[Really Long