Index: /trunk/ippTools/share/receivetool_toadvance.sql
===================================================================
--- /trunk/ippTools/share/receivetool_toadvance.sql	(revision 24105)
+++ /trunk/ippTools/share/receivetool_toadvance.sql	(revision 24106)
@@ -9,7 +9,8 @@
     JOIN receiveSource USING(source_id)
     JOIN receiveFile USING(fileset_id)
-    JOIN receiveResult USING(file_id)
+    LEFT JOIN receiveResult USING(file_id)
 WHERE receiveFileset.state = 'new' 
     AND receiveFileset.fault = 0
 GROUP BY fileset_id 
 HAVING COUNT(receiveFile.file_id) = COUNT(receiveResult.file_id) 
+    AND SUM(receiveResult.fault) = 0