Index: trunk/ippTools/share/dettool_stop_completed_correct_runs.sql
===================================================================
--- trunk/ippTools/share/dettool_stop_completed_correct_runs.sql	(revision 20310)
+++ trunk/ippTools/share/dettool_stop_completed_correct_runs.sql	(revision 20375)
@@ -1,2 +1,3 @@
+-- det1 is the 'correction' detRun, det2 is the 'parent' detRun 
 UPDATE detRun
 SET state = 'stop'
@@ -8,5 +9,5 @@
     FROM detRun AS det1
     INNER JOIN detRun as det2
-        ON det1.ref_det_run = det2.det_id 
+        ON det1.ref_det_id = det2.det_id 
 	-- do we need to restrict by iteration?  not clear this logic below is right or tested
     JOIN detNormalizedImfile as imfile