> Hi,
>
> I always have problem with GROUP BY when work on a complex query
> because
> every selected field must be listed in GROUP BY. And I hate this thing.
> I found this: http://www.firebirdfaq.org/faq304
> Is this an official and safe solution?
>
> Gabor

official? safe?
If the query returns the results you are after then it's official.
If the server doesn't crash and shouldn't, because it's white legitimate
SQL, then it's safe.
The MIN, MAx are aggregate functions so the results with them will not be
the same as without them unless you are sure unique field values are
insignificant.
Alan