Changeset 14059 for trunk/ippTools/share/dettool_toresidexp.sql

Timestamp:

Jul 6, 2007, 4:50:21 PM (19 years ago)

Author:

jhoblitt

Message:

remove use of rawExp.imfiles

File:

• trunk/ippTools/share/dettool_toresidexp.sql (modified) (3 diffs)

trunk/ippTools/share/dettool_toresidexp.sql

@@ -36 +36 @@
         detInputExp.include,
         rawExp.camera,
-        rawExp.imfiles,
         rawExp.exp_tag,
         detResidImfile.class_id
@@ -44 +43 @@
     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 +65 @@
         detRun.det_id
     HAVING
-        rawExp.imfiles = COUNT(detResidImfile.class_id)
+        COUNT(rawImfile.class_id) = COUNT(detResidImfile.class_id)
     ) AS toresidexp