Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java
===================================================================
diff -u -r36785 -r36786
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java	(.../SignRecordManagerImpl.java)	(revision 36785)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/signRecord/service/SignRecordManagerImpl.java	(.../SignRecordManagerImpl.java)	(revision 36786)
@@ -915,7 +915,7 @@
 		String sql = String.format("select fta.hospitalNumber, fta.patient, fta.ascriptionDepartment, fta.doctor, fta.surgery "
 				+ "from %s sr "
 				+ "join %s ti on sr.id = ti.signRecordId "
-				+ "left join %s fta on fta.id = ti.invoicePlanID "
+				+ "join %s fta on fta.id = ti.invoicePlanID "
 				+ "where 1=1 "
 				+ "%s "
 				+ "and sr.departCode = '%s'",
@@ -983,7 +983,7 @@
 		
 		String sql = String.format("select fta.hospitalNumber, fta.patient, fta.ascriptionDepartment, fta.doctor, fta.surgery "
 				+ "from %s ti "
-				+ "left join %s fta on fta.id = ti.invoicePlanID "
+				+ "join %s fta on fta.id = ti.invoicePlanID "
 				+ "where %s ",
 				TousseInstance.class.getSimpleName(),
 				ForeignTousseApplication.class.getSimpleName(),