Index: trunk/ippTools/share/dettool_revertresidimfile.sql
===================================================================
--- trunk/ippTools/share/dettool_revertresidimfile.sql	(revision 14266)
+++ trunk/ippTools/share/dettool_revertresidimfile.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detResidImfile
+USING detResidImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidImfile.det_id = detRun.det_id