Changeset 24167 for trunk/ippTools/share/disttool_definebyquery_chip.sql

Timestamp:

May 13, 2009, 11:07:33 AM (17 years ago)

Author:

bills

Message:

fix error in query

File:

• trunk/ippTools/share/disttool_definebyquery_chip.sql (modified) (1 diff)

trunk/ippTools/share/disttool_definebyquery_chip.sql

@@ -11 +11 @@
     AND rawExp.obs_mode = distTarget.obs_mode 
 JOIN rcInterest USING(target_id)
-LEFT JOIN distRun ON distTarget.stage = 'chip' 
+LEFT JOIN distRun ON distRun.stage = 'chip' 
     AND distRun.stage_id = chipRun.chip_id
     AND distRun.clean = distTarget.clean