UPDATE SNAPSHOT  LEFT JOIN ITEMS ON ITEMS.ITM_IDX = SNAPSHOT.ITM_IDX SET SNAPSHOT. = NULL, SNAPSHOT.PPP = ITEMS.PPP, VALUE = SNAPSHOT.PPP*SNAPSHOT.WEIGHT WHERE REC_IDX =  AND PAL_IDX =