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

Timestamp:

Oct 6, 2006, 6:50:35 PM (20 years ago)

Author:

jhoblitt

Message:

fix -rerun SQL

File:

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

trunk/ippTools/src/dettool.c

@@ -4061 +4061 @@
         "   detResidExp.accept"
         " FROM detRun"
-        " LEFT JOIN detInputExp"
+        " JOIN detInputExp"
         "   ON detRun.position = detInputExp.det_id"
         "   AND detRun.iteration = detInputExp.iteration"
-        " LEFT JOIN detResidExp"
+        " JOIN detResidExp"
         "   ON detRun.position = detResidExp.det_id"
         "   AND detRun.iteration = detResidExp.iteration"
@@ -4070 +4070 @@
         " WHERE"
         "   detRun.state = 'run'"
-        "   AND detInputExp.exp_tag IS NOT NULL"
-        "   AND detResidExp.accept IS NOT NULL"
         " GROUP BY"
         "   detRun.position,"