Changeset 15856

Timestamp:

Dec 16, 2007, 12:16:47 PM (18 years ago)

Author:

eugene

Message:

join resid imfile on det norm exp

File:

• trunk/ippTools/share/dettool_toresidimfile.sql (modified) (1 diff)

trunk/ippTools/share/dettool_toresidimfile.sql

@@ -28 +28 @@
     AND detRun.iteration = detNormalizedImfile.iteration
     AND detProcessedImfile.class_id = detNormalizedImfile.class_id
+JOIN detNormalizedExp
+    ON detRun.det_id = detNormalizedExp.det_id
+    AND detRun.iteration = detNormalizedExp.iteration
 LEFT JOIN detResidImfile
     ON detRun.det_id = detResidImfile.det_id