Re: [firebird-support] Table alias with AS in SELECT statement supported?

2011-10-18 Thread Paul Vinkenoog
Hello Reinier, > The Interbase 6 Language Reference mentions column aliases using the AS > notation, but doesn't show AS in table aliases, e.g. (...) > Have I overlooked something, was it already supported in Interbase 6, or > do the docs need updating? The InterBase 6 LangRef needs updating ;-

Re: [firebird-support] Table alias with AS in SELECT statement supported?

2011-10-18 Thread Helen Borrie
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 a

[firebird-support] Table alias with AS in SELECT statement supported?

2011-10-17 Thread reinier_olislagers
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