Thanks for your answers!

I will have a look on how it could be done with a SP.

Problem is that I'm i a Write First Learn Later situation! 22 Hours
till I'm at customer site installing. Guess I have to skip this
ALARM_GRP field and add it in a update later.

Have a nice day everyone.
/Johan

>
> Unfortunately, what Svend wrote is correct. And, that is the SQL
> standard as well. If using aggregated fields, then all non-

aggregated

> fields have to be included in the GROUP BY clause. Otherwise, the
> resulting data can be unpredictable.
> ...
> Have you considered creating a stored procedure?
>
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)