Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsStorageRecordManagerImpl.java =================================================================== diff -u -r13188 -r13637 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsStorageRecordManagerImpl.java (.../DisposableGoodsStorageRecordManagerImpl.java) (revision 13188) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DisposableGoodsStorageRecordManagerImpl.java (.../DisposableGoodsStorageRecordManagerImpl.java) (revision 13637) @@ -80,7 +80,7 @@ sb.append(" mt.amount,null as price,mt.totalPrice as totalPrice,dg.name,dg.specification "); sb.append(" from ReturnGoodsRecord rgr inner join DisposableGoods dg on dg.id = " + disposableGoodsId); sb.append(" inner join "); - sb.append(" (select rgr.id as recordId,rgi.diposableGoodsID as disposableGoodsId, sum(rgi.amount) as amount,sum(rgi.amount*rgi.price) as totalPrice from ReturnGoodsRecord rgr inner join ReturnGoodsItem rgi on rgi.returnGoodsRecord_ID = rgr.id group by rgi.diposableGoodsID,rgr.id) mt "); + sb.append(" (select rgr.id as recordId,rgi.disposableGoodsID as disposableGoodsId, sum(rgi.amount) as amount,sum(rgi.amount*rgi.price) as totalPrice from ReturnGoodsRecord rgr inner join ReturnGoodsItem rgi on rgi.returnGoodsRecord_ID = rgr.id group by rgi.disposableGoodsID,rgr.id) mt "); sb.append(" on mt.recordId = rgr.id and mt.disposableGoodsId = "); sb.append(disposableGoodsId); sb.append(" where ");