Changeset 21334

Timestamp:

Feb 5, 2009, 11:43:09 AM (17 years ago)

Author:

bills

Message:

simplify query

File:

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

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -9 +9 @@
     rawExp.telescope,
     rawExp.filelevel
-FROM chipImfile
-JOIN chipRun
-    USING(chip_id)
+FROM chipRun
 JOIN rawExp
     USING(exp_id)
 JOIN rawImfile
     ON rawExp.exp_id = rawImfile.exp_id
-    AND chipImfile.class_id = rawImfile.class_id
     AND rawImfile.ignored = 0
+JOIN chipImfile
+    USING(chip_id, class_id)
 LEFT JOIN chipProcessedImfile
     ON chipRun.chip_id = chipProcessedImfile.chip_id