Changeset 25838 for trunk/ippTools/share/disttool_pending_raw.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_raw.sql (modified) (2 diffs)

trunk/ippTools/share/disttool_pending_raw.sql

@@ -17 +17 @@
     rawImfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN rawExp ON rawExp.exp_id = stage_id
 JOIN rawImfile USING(exp_id)
@@ -52 +52 @@
     rawExp.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN rawExp ON exp_id = stage_id
 LEFT JOIN distComponent