Skip to content

Instantly share code, notes, and snippets.

Last active Sep 24, 2015
What would you like to do?
-- this select gets correct data
SELECT `rez_clubs`.`id`, `rez_clubs`.`name`, SUM(`rez_participants`.`points_1`)
FROM `rez_clubs`
JOIN `rez_participants` ON `rez_participants`.`club_id` = `rez_clubs`.`id`
GROUP BY `rez_participants`.`club_id`
-- what im trying to achieve
UPDATE `rez_clubs`
JOIN `rez_participants`
SET `rez_clubs`.`points_1` = SUM(`rez_participants`.`points_1`)
WHERE `rez_clubs`.`id` = `rez_participants`.`club_id`
GROUP BY `rez_clubs`.`id`
Copy link

Naktibalda commented Sep 24, 2015

UPDATE `rez_clubs`
  SELECT `club_id`, SUM(`rez_participants`.`points_1`) AS points_sum
  FROM  `rez_participants` 
  GROUP BY `club_id`
) AS club_points
ON club_id =
SET rez_clubs.points_1 = club_points.points_sum

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment