Changeset 17216 for trunk/ippTools/share/camtool_revertprocessedexp.sql

Timestamp:

Mar 28, 2008, 3:57:39 PM (18 years ago)

Author:

jhoblitt

Message:

add camtool -revertprocessedexp query support

File:

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

trunk/ippTools/share/camtool_revertprocessedexp.sql

@@ -1 +1 @@
 DELETE FROM camProcessedExp
+USING camProcessedExp, camRun, chipRun, rawExp
 WHERE
-    fault != 0
+    camRun.cam_id = camProcessedExp.cam_id
+    AND camRun.chip_id = chipRun.chip_id
+    AND chipRun.exp_id = rawExp.exp_id
+    AND camProcessedExp.fault != 0