>>SELECT MIN(PrimaryKey),SecondaryKey FROM Table ;
>>INTO CURSOR TEMP ;
>>GROUP BY 2

>I was looking to solve this one from the left side instead of the right side. :)

please explain left and right sides from a single table.

If not the simple Select above, then it might be a montrously convoluted mess if it's possible at all. (i use a few Select Messes, they're not pretty to look at- but they work really well anyway)