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