Changeset 16025 for trunk/ippTools/share/warptool_tooverlap.sql

Timestamp:

Jan 7, 2008, 4:31:17 AM (18 years ago)

Author:

eugene

Message:

join against chipProcessedImfile was multiplying output results by a factor of Nimfiles, and is not needed; changed to join against chipRun.exp_id

File:

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

trunk/ippTools/share/warptool_tooverlap.sql

@@ -11 +11 @@
 JOIN chipRun
     ON camProcessedExp.chip_id = chipRun.chip_id
-JOIN chipProcessedImfile
-    ON chipRun.chip_id = chipProcessedImfile.chip_id
 JOIN rawExp
-    ON chipProcessedImfile.exp_id = rawExp.exp_id
+    ON chipRun.exp_id = rawExp.exp_id
 LEFT JOIN warpSkyCellMap
     ON warpInputExp.warp_id = warpSkyCellMap.warp_id