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

Timestamp:

Feb 15, 2008, 9:58:12 AM (18 years ago)

Author:

eugene

Message:

fixed sql to work with master and register images

File:

• trunk/ippTools/share/detselect_search.sql (modified) (2 diffs)

trunk/ippTools/share/detselect_search.sql

@@ +1 @@
+-- this query needs to use the same fields in both of the tables in
+-- the union statement, but we need to report the
+-- detRunSummary.iteration in the first case, and this is missing in
+-- the second case.
+
 SELECT DISTINCT
     det_id,
-    iteration,
+    good_iteration as iteration,
     filelevel
 FROM
     (SELECT DISTINCT
-        detRun.*
+        detRun.*,
+        detRunSummary.iteration as good_iteration
     FROM detRun
     JOIN detRunSummary
@@ -14 +20 @@
     UNION
     SELECT DISTINCT
-        *
+        detRun.*,
+        detRun.iteration as good_iteration
     FROM detRun
     WHERE