Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql =================================================================== diff -u -r37564 -r37566 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37564) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37566) @@ -7,9 +7,12 @@ ), discountPrice=( select td.discountPrice from TousseDefinition td where id=TousseInstance.tousseDefinition_id +), + fluctuationPrice=( +select td.price from TousseDefinition td where id=TousseInstance.tousseDefinition_id ) where comboTousseInstanceId is not null and price<>( select td.price from TousseDefinition td where id=TousseInstance.tousseDefinition_id ) and not exists ( select 1 from Sterilizer s join sterilizationRecord sr on sr.sterilizer_id=s.id where rapidFurnace='是' and sr.id=TousseInstance.id -); \ No newline at end of file +) ; \ No newline at end of file