Changeset 25838 for trunk/ippTools/share/disttool_pending_chip.sql

Timestamp:

Oct 14, 2009, 11:36:17 AM (17 years ago)

Author:

bills

Message:

disambiguate field by finishing the join

File:

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

trunk/ippTools/share/disttool_pending_chip.sql

@@ -6 +6 @@
     stage_id,
     chipProcessedImfile.class_id AS component,
-    clean,
+    distRun.clean,
     rawExp.camera,
     CONCAT_WS('.', outroot, CONVERT(distRun.dist_id, CHAR)) as outdir,
@@ -17 +17 @@
     chipProcessedImfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN chipRun ON chipRun.chip_id = distRun.stage_id
 JOIN rawExp using(exp_id)