I thought all I querry is a DISTINCT selection on a primary table with four
JOINs on orthogonal tables linked by primary keys and some restrictions
in some of the JOINs pertaining to the JOINs using the ON links and
restrictions.

Best Regards
Hans

----- Original Message -----
From: "Ivan Prenosil" <Ivan.Prenosil@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, December 05, 2006 3:55 AM
Subject: Re: [firebird-support] More FB 2.0 / FB1.5 optimizer differences


>> > select distinct o.mud_name oil_co,
>> > s.lsd,
>> > s.date_started,
>> > m.mud_name
>> >
>> > from sites s
> ...
>
>> 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...
>
> There are no aggregate functions, so it is o.k.
>
> Ivan
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>