Michel,

The following will also work:

SELECT NonMember2, SUM(Point) AS SumOfPoint ;
  FROM Point ;
  INTO CURSOR Temp ;
  GROUP BY NonMember2 ;
  ORDER BY SumOfPoint DESCENDING

Your problem was that it didn't know which "Point" to order by.


>
>How come on the following SQL:
>>
>>

>>SELECT NOMEMBER2,SUM(POINT) AS POINT FROM POINT;
>> GROUP BY 1 ORDER BY POINT DESCENDING INTO CURSOR TEMP
>>

>>
>>I would end up with a sort with the following values in my POINT column: 10, 10, 2, 2, 12?
>>
>>The record with 12 as the POINT value should be ranked 1st.
>
>Order by 2 solved it.