Changeset 34786 for branches/czw_branch/20120906/ippTools/share/staticskytool_defineskycalrun.sql

Timestamp:

Dec 10, 2012, 4:35:46 PM (14 years ago)

Author:

watersc1

Message:

Merge from trunk

Location:

branches/czw_branch/20120906

Files:

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

branches/czw_branch/20120906/ippTools/share/staticskytool_defineskycalrun.sql

@@ -2 +2 @@
     sky_id,
     stack_id,
+    skycell_id,
+    filter,
     staticskyRun.workdir,
     staticskyRun.label,
@@ -11 +13 @@
     JOIN stackRun USING(stack_id)
     JOIN stackSumSkyfile USING(stack_id)
+    JOIN skycell USING(tess_id, skycell_id)
     LEFT JOIN skycalRun USING(sky_id, stack_id)
 WHERE staticskyRun.state = 'full'