>>>If so, this combination should do it (note slight change in first SQL)

SELECT MIN(PrimaryKey) AS pk, SecondaryKey AS sk ;
>>>FROM Table INTO CURSOR TEMP ;
>>>GROUP BY 2
>>>* now choose smaller of two for first column
>>>SELECT EVAL("MIN(pk,sk)") AS pk, sk FROM temp

>>
>>Thanks to all who helped me on this.
>>
>>I chose this approach. I guess all approaches sent are good as well. And, the speed is good as well.
>
>As usual, the Fox gives us *many* ways to solve a problem.

And here's one more. The non-SQL approach:

INDEX ON SecondaryKey TO whatever UNIQUE
COPY FIELDS PrimaryKey,SecondaryKey TO whatever