[thelist] MYSQL - join a table, to itself?

[r937]

nice one, jason

tris, i would opt for the simple approach

   SELECT calctype
        , SUM(points)
     FROM statement
   GROUP
       BY calctype

;o)