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

Timestamp:

Oct 10, 2006, 11:06:33 AM (20 years ago)

Author:

jhoblitt

Message:

tweak processedimfile sql

File:

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

trunk/ippTools/src/dettool.c

@@ -1439 +1439 @@
         " FROM detProcessedImfile"
         " JOIN detRun"
-        "   ON detRun.det_id = detProcessedImfile.det_id"
+        "   USING(det_id)"
         " JOIN detInputExp"
         "   ON detRun.det_id = detInputExp.det_id"
         "   AND detRun.iteration = detInputExp.iteration"
-        "   AND detInputExp.exp_tag = detProcessedImfile.exp_tag"
+        "   AND detProcessedImfile.exp_tag = detInputExp.exp_tag"
         " WHERE"
         "   detRun.state = 'run'"