--- In ib-support@y..., Helen Borrie <helebor@w...> wrote:

> At 05:25 PM 20-02-01 -0500, Paul Schmidt wrote:
> >
> >Hello List:
> >
> >I have a Paradox query that contains roughly the following syntax,
> >okay I retyped it, and changed the table and field names to protect
> >the guilty (me :-).
> >
> >SELECT
> >FS.NAME AS FS_NAME,
> >TS.NAME AS TS_NAME
> >FROM WAYBILL AS WB
>
> "AS" isn't used for aliasing table names... <...>

For what little it's worth, the SQL92 standard says AS is optional
keyword when you are specifying column aliases and table aliases.

HOWEVER, if you check subclause 6.3 <table reference>, Leveling Rule
2. b) says that for Entry Level conformance:
"The optional <key word> AS shall not be specified."

There is no such escape clause in SQL92 rules for column aliases
(check rules for subclause 7.9 <query spec>), so in theory the keyword
AS should be valid (though optional) to give alternate name to a
column thing ... but there's theory and there's life, and InterBase
doesn't do the column alias thing well anyway ...

Cheers,
db