Subject Re: [Firebird-Java] Wired AS-clause problem
Author Roman Rokytskyy
> SQL92 Spec
> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

Ok, so we have:

<query specification> ::=
SELECT [ <set quantifier> ] <select list> <table expression>

<select list> ::=
<asterisk>
| <select sublist> [ { <comma> <select sublist> }... ]

<select sublist> ::=
<derived column>
| <qualifier> <period> <asterisk>

<derived column> ::= <value expression> [ <as clause> ]

<as clause> ::= [ AS ] <column name>

"AS" is optional.

Roman