Subject | Table alias with AS in SELECT statement supported? |
---|---|
Author | reinier_olislagers |
Post date | 2011-10-18T05:24:50Z |
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?
Thanks.
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?
Thanks.