--- In firebird-support@yahoogroups.com, Nando Dessena <nando@...> wrote:

>
> Jack,
>
> j> More simply it could be a firebird bug!
>
> it's rather an incomplete support for SQL aliases, and it's more or
> less documented. Your example works fine and produces the expected
> result in Fb 2.
>
> Helen,
>
> H> What is the parser supposed to deduce if you
> H> duplicate the table name as its alias?
>
> aliases hide table names. They didn't do that always in Fb 1.x. The
> parser ain't able to distinguish a dumb alias from a smart one. :-)
>
> Ciao
> --
> Nando Dessena
> ======================================================
> I support Firebird, I am a Firebird Foundation member!
> Join today at http://www.firebirdsql.org/ff/foundation
> ======================================================
>

Thanks for your reply!

Ciao

Jack