SELECT NonMember2, SUM(Point) AS SumOfPoint ; FROM Point ; INTO CURSOR Temp ; GROUP BY NonMember2 ; ORDER BY SumOfPoint DESCENDINGYour problem was that it didn't know which "Point" to order by.
>>SELECT NOMEMBER2,SUM(POINT) AS POINT FROM POINT; >> GROUP BY 1 ORDER BY POINT DESCENDING INTO CURSOR TEMP >>>>