Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.39_4.9.40.sql
===================================================================
diff -u -r27337 -r27368
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.39_4.9.40.sql	(.../4.9.39_4.9.40.sql)	(revision 27337)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.39_4.9.40.sql	(.../4.9.39_4.9.40.sql)	(revision 27368)
@@ -5,4 +5,4 @@
 update TousseInstance set materialAmount=(select sum(mi.count) amount from TousseInstance ti inner join TousseDefinition td  on td.id = ti.toussedefinition_id inner join MaterialInstance mi on mi.tousse_id = td.id where TousseInstance.id=ti.id);
 update InvoiceItem set materialAmount=(select sum(mi.count) amount from InvoiceItem ii inner join TousseDefinition td  on td.id = ii.tousseDefinitionId inner join MaterialInstance mi on mi.tousse_id = td.id where InvoiceItem.id=ii.id);
 update ReturnGoodsItem set materialAmountAtThatTime=(select sum(mi.count) amount from ReturnGoodsItem ri inner join TousseDefinition td  on td.id = ri.toussedefinition_id inner join MaterialInstance mi on mi.tousse_id = td.id where ReturnGoodsItem.id=ri.id);
-update TousseDefinition set materialAmount=(select sum(mi.count) amount from TousseDefinition td inner join MaterialInstance mi on mi.tousse_id = td.id where td.id=TousseDefinition.id);
\ No newline at end of file
+update TousseDefinition set materialAmount=(select sum(mi.count) amount from MaterialInstance mi where mi.tousse_id = TousseDefinition.id);
\ No newline at end of file