>>>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)
I meant I was looking for a special syntax of the GROUP BY which would have achieved all that while the solution was using the MIN on the fields with a GROUP on the secondary field. I never thought of applying something on the fields in the first case.