sql - MySQL: UPDATE with SUM and JOIN - Stack Overflow

UPDATE aliaspoint INNER JOIN achiever ON .... You're missing the GROUP BY clause in: SET points ...

stackoverflow.com