USE stockB SELECT barcode, SUM(qty) AS qty ; FROM StockB ; GROUP BY 1 ; INTO CURSOR StockTemp INDEX ON barcode TAG barcode SET ORDER TO barcode USE stockA in 0 SELECT stockA SET RELATION TO barcode INTO StockTemp REPLACE ALL qty WITH stockA.qty + StockTemp.qty IN stockAHere's another way
Dimension laQty[1] USE stockA in 0 SELECT stockA Scan laQty[1] = 0 SELECT SUM(qty) AS qty ; FROM StockB ; WHERE StockB.barcode = StockA.barcode ; INTO ARRAY laQty REPLACE StockA.qty WITH stockA.qty + laQty[1] ENDSCANAFAIK, You cannot do this using SQL Update because in VFP it doesn't support neither join condition in where clause nor query in the SET clause.
>USE stockB >SET ORDER TO barcode > >USE stockA in 0 >SELECT stockA >SET RELATION TO barcode INTO stockB > >REPLACE ALL qty WITH stockA.qty + stockB.qty IN stockA >