Changeset 31628 for branches/eam_branches/ipp-20110505/ippTools/share/addtool_find_sky_id.sql

Timestamp:

Jun 15, 2011, 5:25:23 AM (15 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/eam_branches/ipp-20110505

Files:

• . (modified) (1 prop)
• ippTools/share/addtool_find_sky_id.sql (modified) (2 diffs)

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

@@ -3 +3 @@
 FROM 
      staticskyResult
-join staticSkyRun using (sky_id)
-join staticSkyInput using (stack_id)
+join staticskyRun using (sky_id)
+join staticskyInput using(sky_id)
 JOIN stackRun USING(stack_id)
 
@@ -13 +13 @@
           ) as foo
      ON sky_id = added_sky_id 
-     AND stage = 'sky'
+     AND stage = 'staticsky'
      -- hook for qualifying the join on the previous_dvodb
      AND %s