Changeset 31439 for branches/eam_branches/ipp-20110404/ippTools/share/addtool_find_cam_id.sql

Timestamp:

May 5, 2011, 10:05:10 AM (15 years ago)

Author:

eugene

Message:

merging updates from trunk

File:

• branches/eam_branches/ipp-20110404/ippTools/share/addtool_find_cam_id.sql (modified) (1 diff)

branches/eam_branches/ipp-20110404/ippTools/share/addtool_find_cam_id.sql

@@ -11 +11 @@
                   addRun.dvodb AS previous_dvodb
            FROM addRun
-           JOIN camRun USING(cam_id)
+           JOIN camRun on cam_id=stage_id
            JOIN chipRun USING(chip_id)
           ) as foo
      ON exp_id = added_exp_id
+     AND stage = 'cam'
      -- hook for qualifying the join on the previous_dvodb
      AND %s