Changeset 27838 for branches/tap_branches/ippTools/share/addtool_find_cam_id.sql

Timestamp:

May 3, 2010, 8:41:49 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/tap_branches

Files:

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

branches/tap_branches/ippTools/share/addtool_find_cam_id.sql

@@ -6 +6 @@
 JOIN rawExp
     USING(exp_id)
+LEFT JOIN (SELECT exp_id       AS added_exp_id,
+                  addRun.dvodb AS previous_dvodb
+           FROM addRun
+           JOIN camRun USING(cam_id)
+           JOIN chipRun USING(chip_id)
+          ) as foo
+     ON exp_id = added_exp_id
+     -- hook for qualifying the join on the previous_dvodb
+     AND %s
 WHERE
     camRun.state = 'full'
+    AND added_exp_id IS NULL
+    -- addtool adds checks on exposure being added to the dvodb previously