Index: trunk/ippTools/share/dettool_toresidexp.sql
===================================================================
--- trunk/ippTools/share/dettool_toresidexp.sql	(revision 14045)
+++ trunk/ippTools/share/dettool_toresidexp.sql	(revision 14059)
@@ -36,5 +36,4 @@
         detInputExp.include,
         rawExp.camera,
-        rawExp.imfiles,
         rawExp.exp_tag,
         detResidImfile.class_id
@@ -44,8 +43,11 @@
     JOIN rawExp
         ON detInputExp.exp_id = rawExp.exp_id
-    JOIN detResidImfile
+    JOIN rawImfile
+        on rawExp.exp_id = rawImfile.exp_id
+    LEFT JOIN detResidImfile
         ON detRun.det_id = detResidImfile.det_id
         AND detRun.iteration = detResidImfile.iteration
         AND detInputExp.exp_id = detResidImfile.exp_id
+        AND rawImfile.class_id = detResidImfile.class_id
     LEFT JOIN detResidExp
         ON detResidImfile.det_id = detResidExp.det_id
@@ -63,4 +65,4 @@
         detRun.det_id
     HAVING
-        rawExp.imfiles = COUNT(detResidImfile.class_id)
+        COUNT(rawImfile.class_id) = COUNT(detResidImfile.class_id)
     ) AS toresidexp