Changeset 19258 for trunk/ippTools/share/stacktool_definebyquery_part2.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_part2.sql (modified) (2 diffs)

trunk/ippTools/share/stacktool_definebyquery_part2.sql

@@ -13 +13 @@
     SELECT
         skycell_id,
-        tess_id,
+        stackRun.tess_id as stack_tess_id,
         filter,
         COUNT(stackInputSkyfile.warp_id) as num_stack -- number of warps in a stack
@@ -22 +22 @@
         ) AS stackSizes
     -- JOINing the warpsToStack and stackSizes tables
-        USING(skycell_id, tess_id, filter)
+        USING(skycell_id, filter)
         )
     GROUP BY
         skycell_id,
-        tess_id,
         filter