UPDATE MEMBERSHIP M,PROJECTINFO P,CONTRIBUTERATIO C
SET M.SCORE = P.SCORE*C.RATIO/100
WHERE P.ID = M.ITEMID
AND M.MEMBERCOUNT = c.MEMBERCOUNT
AND M.ROLE = c.ROLE
AND M.ITEMTYPE = C.ITEMTYPE
AND P.YEAR = ?;