Changeset 14023 for trunk/ippTools/share/camtool_find_pendingimfile.sql

Timestamp:

Jul 5, 2007, 3:16:08 PM (19 years ago)

Author:

jhoblitt

Message:

rename exp_id -> exp_name
rename exp_tag -> exp_id
add add rawExp.exp_tag for use as an external name only

File:

• trunk/ippTools/share/camtool_find_pendingimfile.sql (modified) (3 diffs)

trunk/ippTools/share/camtool_find_pendingimfile.sql

@@ -4 +4 @@
     (SELECT
         camPendingExp.*,
-        chipProcessedExp.exp_tag,
+        chipProcessedExp.exp_id,
         chipProcessedExp.guide_id,
         chipProcessedImfile.class_id,
@@ -12 +12 @@
         chipProcessedImfile.bg_mean_stdev,
         chipProcessedImfile.path_base,
-        rawExp.exp_id,
+        rawExp.exp_name,
         rawExp.camera,
         rawExp.telescope,
@@ -22 +22 @@
         USING(chip_id)
     JOIN rawExp
-        ON chipProcessedExp.exp_tag = rawExp.exp_tag
+        ON chipProcessedExp.exp_id = rawExp.exp_id
     LEFT JOIN camProcessedExp
         ON camPendingExp.cam_id = camProcessedExp.cam_id