Changeset 9079

Timestamp:

Sep 29, 2006, 6:06:57 PM (20 years ago)

Author:

jhoblitt

Message:

fix -toprocessedexp sql

File:

• trunk/ippTools/src/dettool.c (modified) (2 diffs)

trunk/ippTools/src/dettool.c

@@ -1082 +1082 @@
         "    AND detInputExp.exp_tag = detProcessedImfile.exp_tag"
         " LEFT JOIN detProcessedExp"
-        "    ON detInputExp.det_id = detStackedImfile.det_id"
-        "    AND detInputExp.iteration = detStackedImfile.iteration"
-        "    AND detProcessedImfile.exp_tag= detStackedImfile.exp_tag"
+        "    ON detInputExp.det_id = detProcessedExp.det_id"
+        "    AND detProcessedImfile.exp_tag= detProcessedExp.exp_tag"
         " LEFT JOIN rawImfile"
         "    ON detInputExp.exp_tag = rawImfile.exp_tag"
@@ -1090 +1089 @@
         " WHERE"
         "    detProcessedExp.det_id IS NULL"
-        "    AND detProcessedExp.iteration IS NULL"
         "    AND detProcessedExp.exp_tag IS NULL"
         "    AND detInputExp.include = 1"