Changeset 19609 for branches/eam_branch_20080918/ippTools/share/dettool_childlessrun.sql

Timestamp:

Sep 18, 2008, 6:39:14 PM (18 years ago)

Author:

eugene

Message:

added ref_det_id, ref_iter references for verify mode and populate as needed

File:

• branches/eam_branch_20080918/ippTools/share/dettool_childlessrun.sql (modified) (1 diff)

branches/eam_branch_20080918/ippTools/share/dettool_childlessrun.sql

@@ -5 +5 @@
  FROM detRun
  LEFT JOIN detRun as foo
-   ON foo.parent = detRun.det_id
+   ON foo.ref_det_id = detRun.det_id
+-- XXX do we need to restrict to foo.ref_iter = detRun.iteration ?   
  WHERE
    detRun.state = 'stop'