Changeset 25073

Timestamp:

Aug 14, 2009, 12:29:17 PM (17 years ago)

Author:

Paul Price

Message:

Get exp_name as well as exp_id.

File:

• trunk/ippTools/share/difftool_skyfile.sql (modified) (1 diff)

trunk/ippTools/share/difftool_skyfile.sql

@@ -18 +18 @@
     rawInput.exp_time,
     rawInput.camera,
-    rawInput.exp_id AS exp1,
-    rawTemplate.exp_id AS exp2
+    rawInput.exp_name AS exp_name_1,
+    rawTemplate.exp_name AS exp_name_2,
+    rawInput.exp_id AS exp_id_1,
+    rawTemplate.exp_id AS exp_id_2
 FROM diffRun
 JOIN diffSkyfile USING(diff_id)