jack_it_m wrote:

> I posted this weird behaviuor just because I discovered it for a
> strange case while I was using Crystal Reports. It always use the
> table name as its alias.
>
> Thanks
> Jack
>

Jack,

I use a lot Crystal and I hate the way it create the SQL :-(

As far as I can understood, FB give the problem you mention only if the
same table are used more than once in the query and the first alias is
the default table name and the other real aliases.

If the query has the table only one time even if it uses the alias
exactly as the table name you should not expect any trouble.

But the alias as the same as the table name has no sense at all, Crystal
has it by default because of desktop databases like dbase files, Crystal
would create a query like this using DBF files:

select
Foo.Bar
from
"c:\DBF_Files\FOO.DBF" Foo
where
Foo.Bar = 123

in a FB database with the same table Foo the query will be

select
Foo.Bar
from
Foo Foo
where
Foo.Bar = 123

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br