Subject Re: [firebird-support] More FB 2.0 / FB1.5 optimizer differences
Author Ann W. Harrison
Hans wrote:
> What I'm I doing wong ?
> Any ideas ?

Your select list is odd in that it has a DISTINCT and then
a series of simple field references. That probably makes
sense in your application but I don't know that it's legal
SQL. I'd expect to see that done with a GROUP BY...


Regards,


Ann