>>
select Field1, Field2 .. group by Field1, Field2
>>is the same as
>>
>>
select distinct Field1, Field2
>
>Yes, I will have to go through the other replies later on today. But, as is, this queries is ok with me. I didn't have to include additional fields. That's the part I didn't understand. I'll be back later on today on this.
The DISTINCT in your particular situation would probably be the easiest solution. Otherwise solution by Borislav will work (though I didn't test it).
If it's not broken, fix it until it is.
My Blog