Changeset 31434 for branches/czw_branch/20110406/ippTools/share/addtool_find_cam_id.sql

Timestamp:

May 4, 2011, 3:20:38 PM (15 years ago)

Author:

watersc1

Message:

Merging trunk into this branch

Location:

branches/czw_branch/20110406

Files:

• . (modified) (1 prop)
• ippTools/share/addtool_find_cam_id.sql (modified) (1 diff)

branches/czw_branch/20110406/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