>Michel,

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

Now, what if I need to extract the minimum value between the primary key and the secondary key. Because, on some results, it may be that the result includes a record which is having the secondary key higher than the primary key.

In coding, we would have MIN(1,2) which will return 1. However, in a SQL syntax, it returns an error betwen MIN(PrimaryKey,SecondaryKey).