Changeset 14698 for trunk/ippTools/share/warptool_imfile.sql

Timestamp:

Aug 29, 2007, 3:18:45 PM (19 years ago)

Author:

eugene

Message:

fixed SQL error yielding multiple copies of the chip imfiles

File:

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

trunk/ippTools/share/warptool_imfile.sql

@@ -15 +15 @@
     ON camProcessedExp.chip_id = chipProcessedImfile.chip_id
 JOIN rawImfile -- is there any reason not to refer back to rawimfiles?
-    ON chipProcessedImfile.exp_id = rawImfile.exp_id
+    ON chipProcessedImfile.exp_id = rawImfile.exp_id AND chipProcessedImfile.class_id = rawImfile.class_id 
 WHERE
     warpRun.state = 'run'