Changeset 15956

Timestamp:

Dec 30, 2007, 5:00:44 PM (18 years ago)

Author:

eugene

Message:

sql was returning Nchip x the desired result

File:

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

trunk/ippTools/share/camtool_find_pendingexp.sql

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