Index: /trunk/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- /trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 14057)
+++ /trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 14058)
@@ -12,5 +12,5 @@
     (SELECT 
         chipRun.*,
-        rawExp.imfiles,
+        rawImfile.class_id as rawimfile_class_id,
         chipProcessedImfile.class_id
     FROM chipRun
@@ -19,5 +19,7 @@
     JOIN rawExp
         ON chipInputImfile.exp_id = rawExp.exp_id
-    JOIN chipProcessedImfile
+    JOIN rawImfile
+        ON rawExp.exp_id = rawImfile.exp_id
+    LEFT JOIN chipProcessedImfile
         ON chipInputImfile.chip_id = chipProcessedImfile.chip_id
         AND chipInputImfile.exp_id = chipProcessedImfile.exp_id
@@ -29,3 +31,4 @@
         chipInputImfile.chip_id,
         chipInputImfile.exp_id
-    HAVING rawExp.imfiles = COUNT(chipProcessedImfile.class_id)) as Foo
+    HAVING COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+    ) as Foo