>>>>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
But that would not always give the *lowest* PrimaryKey for each SecondaryKey, which was part of the requirement.