update item ii INNER JOIN lineitem on ii.id=lineitem.itemId set ii.sti=ii.sti+(select SUM(ll.quantity) from lineitem ll where ll.status=3 and ll.itemId=ii.id group by ii.id ) where lineitem.status=3

------解决方案--------------------
探讨


引用:

SQL code

update item ii INNER JOIN lineitem on ii.id=lineitem.itemId set ii.sti=ii.sti+(select SUM(ll.quantity) from lineitem ll where ll.status=3 and ll.itemId=ii.id group by ii.i……


------解决方案--------------------
SQL code

UPDATE ii SET ii.id=ii.id+SUM(li.quantity) FROM item  ii 
INNER JOIN lineitem li ON li.itemId=ii.id
WHERE li.status=3  
GROUP BY li.itemid,ii.id