Changeset 19078 for branches/eam_branch_20080719/ippTools/share/dettool_pendingcleanup_processedexp.sql

Timestamp:

Aug 14, 2008, 3:28:57 PM (18 years ago)

Author:

eugene

Message:

various fixes to the get command-line options for cleanup stages correct

File:

• branches/eam_branch_20080719/ippTools/share/dettool_pendingcleanup_processedexp.sql (modified) (1 diff)

branches/eam_branch_20080719/ippTools/share/dettool_pendingcleanup_processedexp.sql

@@ +1 @@
+-- need to restrict to a single detRunSummary (require all to say 'cleaned'?)
 SELECT
     detProcessedExp.*,
-    detRunSummary.data_state,
+    detRunSummary.data_state
 FROM detRunSummary
 JOIN detProcessedExp
-    USING(det_id,iteration)
+    USING(det_id)
 WHERE
     detRunSummary.data_state = 'goto_cleaned'