Changeset 36137 for trunk/ippTools/share

Timestamp:

Sep 19, 2013, 3:03:49 PM (13 years ago)

Author:

bills

Message:

include staticsky_path_base and sky_id in the output of releasetool -listrelstack

File:

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

trunk/ippTools/share/releasetool_listrelstack.sql

@@ -10 +10 @@
     skycalResult.path_base AS skycal_path_base,
     skycalRun.data_group AS skycal_data_group,
+    staticskyResults.sky_id AS sky_id,
+    staticskyResult.path_base AS staticsky_path_base,
     'GPC1' AS camera
 FROM relStack
@@ -18 +20 @@
 LEFT JOIN skycalRun USING(skycal_id)
 LEFT JOIN skycalResult USING(skycal_id)
+LEFT JOIN staticskyResult USING(sky_id)