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

Timestamp:

Jul 17, 2007, 12:05:17 PM (19 years ago)

Author:

jhoblitt

Message:

rework dettool * detselect's handling for registered detrends

File:

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

trunk/ippTools/share/detselect_search.sql

@@ -1 +1 @@
 SELECT DISTINCT
-    detRunSummary.det_id,
-    detRunSummary.iteration,
-    detRun.filelevel
-FROM detRun
-JOIN detRunSummary
-    USING(det_id)
-WHERE
-   detRun.state = 'stop'
-   AND detRun.mode  = 'master'
-   AND detRunSummary.accept = 1
+    det_id,
+    iteration,
+    filelevel
+FROM
+    (SELECT DISTINCT
+        detRun.det_id,
+        detRun.iteration,
+        detRun.filelevel,
+        detRun.registered
+    FROM detRun
+    JOIN detRunSummary
+        USING(det_id)
+    WHERE
+       detRun.state = 'stop'
+       AND detRun.mode  = 'master'
+       AND detRunSummary.accept = 1
+    UNION
+    SELECT DISTINCT
+        detRun.det_id,
+        detRun.iteration,
+        detRun.filelevel,
+        detRun.registered
+    FROM detRun
+    WHERE
+       detRun.state = 'stop'
+       AND detRun.mode  = 'register'
+    ) as Foo