>Sir I have these code
>
>

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

>
>it says:
>
>File 'sum.prg' does not exist.
>
>Please help

UPDATE cr_sale SET weight= crsalp.TotalWeigth;
FROM cr_sale;
INNER JOIN (SELECT vou_no, SUM(qty*weight) AS TotalWeigth;
                   FROM crsalp;
            GROUP BY vou_no) crsalp ON cr_sale.vou_no=crsalp.vou_no