>>Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9
>>cat dog ... ... ... ... ... ... ...
>>cat mouse
>>fish goat
>>cat dog
>>
>>>select T.* from myTable T ; >INNER JOIN (select field1, field2, min(field3) as uniqueFld3 from myTable group by field1, field2) X ; >on T.field1 = X.field2 and T.field2 = X.field2 and T.field3 = X.field3Thanks!