Changeset 33638 for branches/eam_branches/ipp-20111122/ippTools/share/addtool_find_sky_id.sql

Timestamp:

Mar 30, 2012, 2:49:37 PM (14 years ago)

Author:

eugene

Message:

merge changes from trunk

File:

• branches/eam_branches/ipp-20111122/ippTools/share/addtool_find_sky_id.sql (modified) (2 diffs)

branches/eam_branches/ipp-20111122/ippTools/share/addtool_find_sky_id.sql

@@ -2 +2 @@
     staticskyRun.*
 FROM 
-     staticskyResult
-join staticskyRun using (sky_id)
+     staticskyRun
+join staticskyResult using (sky_id)
 join staticskyInput using(sky_id)
 JOIN stackRun USING(stack_id)
@@ -19 +19 @@
     staticskyRun.state = 'full'
     AND staticskyResult.quality = 0
-    AND added_exp_id IS NULL
+    AND added_sky_id IS NULL
     -- addtool adds checks on exposure being added to the dvodb previously