>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
