>>Hi All:
>>
>>Consider the following table, FOO.
>>
>>

>>Field1   Field2   Field3   Field4   Field5   Field6   Field7   Field8   Field9
>>cat        dog       ...          ...          ...         ...          ...          ...          ...
>>cat        mouse
>>fish       goat
>>cat        dog
>>

>>
>>If I say SELECT FOO.*, I will get 4 records. However, I do not want duplicates of field1+field2. I do not care which record I get.
>>
>>SELE DISTINCT will not work, since there may be differences in the other fields.
>>
>>Thanks,
>>
>>Yossi
>
>If you don't have PK field in your table (you should have it) and field3 is always different, then
>

>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

Thanks!