Changeset 31375 for trunk/ippTools/share/addtool_find_cam_id_dvo.sql

Timestamp:

Apr 25, 2011, 2:59:55 PM (15 years ago)

Author:

heather

Message:

merging in addstar changes to the trunk

File:

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

trunk/ippTools/share/addtool_find_cam_id_dvo.sql

@@ -6 +6 @@
     AND exp_id NOT IN (SELECT exp_id
        FROM addRun
-       JOIN camRun USING(cam_id)
+       JOIN camRun on cam_id=stage_id
        JOIN chipRun USING(chip_id)
-       WHERE %s
+       WHERE stage = 'cam' AND %s
       )