Without the DISTINCT clause, I would get hundreds or more identical rows
back,
basically all customers that bought a product at a certain place. Of course
the same
customer buys the same product at the same place many time over and over in
a
certain time span.

I don't think that I can achieve the same with a GROUP BY. I'll look it up
:)

Currently, the returned results are correct and identical using either
FB1.5
or FB2.0 with an identical ODS11.0 copy of the FB1.5 ODS10.1 database.

Best Regards
Hans

----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, December 04, 2006 3:27 PM
Subject: Re: [firebird-support] More FB 2.0 / FB1.5 optimizer differences


> 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
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>