Index: trunk/ippTools/share/camtool_reset_faulted_runs.sql
===================================================================
--- trunk/ippTools/share/camtool_reset_faulted_runs.sql	(revision 17145)
+++ trunk/ippTools/share/camtool_reset_faulted_runs.sql	(revision 17216)
@@ -1,4 +1,7 @@
-UPDATE camRun, camProcessedExp SET camRun.state = 'run'
+UPDATE camRun, camProcessedExp, chipRun, rawExp
+SET camRun.state = 'run'
 WHERE
     camRun.cam_id = camProcessedExp.cam_id
+    AND camRun.chip_id = chipRun.chip_id
+    AND chipRun.exp_id = rawExp.exp_id
     AND camProcessedExp.fault != 0
Index: trunk/ippTools/share/camtool_revertprocessedexp.sql
===================================================================
--- trunk/ippTools/share/camtool_revertprocessedexp.sql	(revision 17145)
+++ trunk/ippTools/share/camtool_revertprocessedexp.sql	(revision 17216)
@@ -1,3 +1,7 @@
 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
Index: trunk/ippTools/share/chiptool_revertprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_revertprocessedimfile.sql	(revision 17145)
+++ trunk/ippTools/share/chiptool_revertprocessedimfile.sql	(revision 17216)
@@ -1,3 +1,5 @@
 DELETE FROM chipProcessedImfile
+USING chipProcessedImfile, rawExp
 WHERE
-    fault != 0
+    rawExp.exp_id = chipProcessedImfile.exp_id
+    AND chipProcessedImfile.fault != 0