UPDATE cr_sale SET weight=SUM(crsalp.qty*crsalp.weight) from crsalp WHERE cr_sale.vou_no=crsalp.vou_no