Changeset 12790 for trunk/ippTools/share/detselect_search.sql

Timestamp:

Apr 10, 2007, 2:48:54 PM (19 years ago)

Author:

jhoblitt

Message:

remove join against detInputExp & rawExp

File:

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

trunk/ippTools/share/detselect_search.sql

@@ -6 +6 @@
 JOIN detRunSummary
     USING(det_id)
-JOIN detInputExp
-    USING(det_id)
-JOIN rawExp
-    ON detInputExp.exp_tag = rawExp.exp_tag
 WHERE
-   (detRun.state = 'stop' OR detRun.state = 'reg')
+   detRun.state = 'stop'
    AND detRun.mode  = 'master'
    AND detRunSummary.accept = 1