update ClubGroup
set ClubScore = (select sum(ClubContribute) from admins where ClubContribute > 0 and ClubID = ClubGroup.ID)
from ClubGroup
set ClubScore = (select sum(ClubContribute) from admins where ClubContribute > 0 and ClubID = ClubGroup.ID)
from ClubGroup
set ClubScore = (select sum(ClubContribute) from admins where ClubContribute > 0 and ClubID = ClubGroup.ID)
from ClubGroup--如果要考虑空
update ClubGroup
set ClubScore = isnull((select sum(ClubContribute) from admins where ClubContribute > 0 and ClubID = ClubGroup.ID),0)
from ClubGroup