At 06:24 PM 18/10/2011, reinier_olislagers wrote:

>Hi all,
>
>The Interbase 6 Language Reference mentions column aliases using the AS
>notation, but doesn't show AS in table aliases, e.g.
>select * from rdb$relations tables
>
>On Firebird 2.5, this seems to work fine:
>select * from rdb$relations as tables;
>
>I had a look through the Firebird 2.5 Language Reference Update (8
>October 2011, version 1.1, covers Firebird 2.5 and 2.5.1).
>It doesn't seem to say anything about using AS for table aliases in
>SELECT statements.
>
>Have I overlooked something, was it already supported in Interbase 6, or
>do the docs need updating?

Much simpler than that, actually. AS is an optional keyword, just that most people don't bother to use it.

./heLen