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