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
======================================================