Index: ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java
===================================================================
diff -u -r35131 -r35327
--- ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java	(.../XinHuaDataManagerImpl.java)	(revision 35131)
+++ ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/XinHuaDataManagerImpl.java	(.../XinHuaDataManagerImpl.java)	(revision 35327)
@@ -1074,7 +1074,7 @@
 	 */
 	public boolean refreshSterilizaerRecordAmounts(CommonSterilizerRecord xinRecord, String beginStartTimeStr, String endStartTimeStr, String devInterfaceId,Long cycleCounter,String machineNo, boolean enableDetailedDeviceInformation, LoginUserData loginUserData)
 	{
-		String queryString = "select max(sr.id) amount from SterilizationRecord sr join Sterilizer s on s.id=sr.id "
+		String queryString = "select max(sr.id) amount from SterilizationRecord sr join Sterilizer s on s.id=sr.sterilizer_id "
 				+ " where s.deviceInterface_id = "
 				+ devInterfaceId
 				+ " and s.machineNumber = '"