>>

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).