Changeset 19258 for trunk/ippTools/share/stacktool_definebyquery_part1.sql

Timestamp:

Aug 27, 2008, 5:57:36 PM (18 years ago)

Author:

eugene

Message:

do not join against tess_id

File:

• trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) (2 diffs)

trunk/ippTools/share/stacktool_definebyquery_part1.sql

@@ -5 +5 @@
 SELECT
     skycell_id,
+    filter,
     tess_id,
-    filter,
     num_warp,
     MAX(num_stack) AS num_stack
@@ -13 +13 @@
     SELECT
         skycell_id,
-        warpSkyfile.tess_id,
+        warpSkyfile.tess_id as tess_id,
         rawExp.filter,
         COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked