Changeset 20375 for trunk/ippTools/share

Timestamp:

Oct 24, 2008, 3:01:24 PM (18 years ago)

Author:

eugene

Message:

fix correction queries

File:

• trunk/ippTools/share/dettool_stop_completed_correct_runs.sql (modified) (2 diffs)

trunk/ippTools/share/dettool_stop_completed_correct_runs.sql

@@ +1 @@
+-- det1 is the 'correction' detRun, det2 is the 'parent' detRun 
 UPDATE detRun
 SET state = 'stop'
@@ -8 +9 @@
     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