Index: ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/StRoomControlHelper.java
===================================================================
diff -u -r19517 -r20262
--- ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/StRoomControlHelper.java	(.../StRoomControlHelper.java)	(revision 19517)
+++ ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/StRoomControlHelper.java	(.../StRoomControlHelper.java)	(revision 20262)
@@ -97,7 +97,7 @@
             notJoinedBasketWhereSql += String.format(" and %s", typeSql);
         }
         
-        String whereSql = "(" + joinedBasketSql + joinedBasketWhereSql + " union all " + notJoinedBasketSql + notJoinedBasketWhereSql + ") alias " + groupBySql;
+        String whereSql = "(" + joinedBasketSql + joinedBasketWhereSql + " union " + notJoinedBasketSql + notJoinedBasketWhereSql + ") alias " + groupBySql;
         return whereSql;
     }