Changeset 9319 for trunk/ippTools/src/dettool.c

Timestamp:

Oct 5, 2006, 2:59:31 PM (20 years ago)

Author:

jhoblitt

Message:

more reworking of -tonormalizedstat -- mask out the whole frame if any component imfile appears in detNormalizedImfile.

File:

• trunk/ippTools/src/dettool.c (modified) (1 diff)

trunk/ippTools/src/dettool.c

@@ -2168 +2168 @@
         "     detRun.iteration"
         " FROM detRun"
-        " LEFT JOIN detInputExp"
+        " JOIN detInputExp"
         "     ON detRun.position = detInputExp.det_id"
         "     AND detRun.iteration = detInputExp.iteration"
-        " LEFT JOIN rawDetrendExp"
+        " JOIN rawDetrendExp"
         "     ON detInputExp.exp_tag = rawDetrendExp.exp_tag"
-        " LEFT JOIN detStackedImfile"
+        " JOIN detStackedImfile"
         "     ON detInputExp.det_id = detStackedImfile.det_id"
         "     AND detInputExp.iteration = detStackedImfile.iteration"
+        " LEFT JOIN detNormlaizedStatImfile"
+        "     ON detRun.position = detNormalizedStatImfile.det_id"
+        "     ON detRun.iteration = detNormalizedStatImfile.iteration"
         " WHERE"
         "   detRun.state = 'run'"
+        "   AND detNormalizedStatImfile.det_id IS NULL"
+        "   AND detNormalizedStatImfile.iteration IS NULL"
         " GROUP BY"
         "     rawDetrendExp.exp_tag,"