some syntax error in sql server when updating one column of a file with other column ofa other file
update invDB.sum(itmqty)=stkDB.itmsl_rtn from invDB inner join stkDB on invDB.itemid=stkDB.itmcode where stkDB.itmcode=1333
UPDATE stkDB.itmsl_rtn = invDB.SUM(itmqty) FROM ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)