Changeset 27358

Timestamp:

Mar 19, 2010, 12:04:46 PM (16 years ago)

Author:

bills

Message:

disambiguate chip_id

File:

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

trunk/ippTools/share/magicdstool_todestreak_chip.sql

@@ -24 +24 @@
 JOIN camRun USING(cam_id)
 JOIN camProcessedExp USING(cam_id)
-JOIN chipRun ON chip_id = stage_id
-JOIN chipProcessedImfile USING(chip_id)
+JOIN chipRun ON chipRun.chip_id = stage_id
+JOIN chipProcessedImfile ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
 LEFT JOIN magicDSFile