Changeset 18357 for branches/cleanup/ippTools/share/chiptool_pendingcleanuprun.sql

Timestamp:

Jun 29, 2008, 2:44:04 PM (18 years ago)

Author:

eugene

Message:

merge cvs HEAD into cleanup branch

File:

• branches/cleanup/ippTools/share/chiptool_pendingcleanuprun.sql (modified) (1 diff)

branches/cleanup/ippTools/share/chiptool_pendingcleanuprun.sql

@@ -1 +1 @@
 SELECT
-    chipRun.*
+    chipRun.chip_id,
+    rawExp.camera,
+    chipRun.state
 FROM chipRun
+JOIN rawExp 
+USING (exp_id)
 WHERE
     chipRun.state = 'goto_cleaned'