请问如何求值??
MySQL
同一个数据库中有两个表:matware和matinout
matware:fstockcode,fqty06,fwareqty
matinout:fstockcode,finqty,foutqty
请问以下语法如何写:
以matware.fstockcode=matinout.fstockcode为条件,
更新matware.fwareqty=(matware.fqty06+matinout.finqty)-matinout.foutqty
[解决办法]
update matware,matinout
set matware.fwareqty=(matware.fqty06+matinout.finqty)-matinout.foutqty
where matware.fstockcode=matinout.fstockcode
[解决办法]
不對啊
