> Hi again,
>
> Pavel Menshchikov schrieb:
> > Yes, no problems if you haven't upgraded the DB (ODS, I mean). If you
> > have upgraded, you should use 1.5's gbak with 2.0 FB server to backup
> > the DB, then restore it on 1.5 FB server.
>
> I now installed the Firebird SS-1.5.3.4870.nptl.i686 again and made a
> backup of my databases. After that I restored the databases again with
> Firebird 2.0.0.12748-0.nptl.i686. So now the databases should be on the
> new ODS but I still get different results with the mentioned statements.
>
> Just to be sure I executed both statements using the old
> Firebird SS-1.5.3.4870.nptl.i686 and I got the same results.
>
> Do you have another idea why they give different results using the new
> Firebird and the same results when using the old Firebird?
>
> Thanks,
>
> Sascha

best show us your new aliased queries
Alan