Changeset 14023 for trunk/ippTools/share/camtool_find_pendingexp.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_pendingexp.sql (modified) (2 diffs)

trunk/ippTools/share/camtool_find_pendingexp.sql

@@ -4 +4 @@
 SELECT
     camRun.*,
-    rawExp.exp_tag,
     rawExp.exp_id,
+    rawExp.exp_name,
     rawExp.camera,
     rawExp.telescope,
@@ -15 +15 @@
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedImfile.exp_tag = rawExp.exp_tag
+    ON chipProcessedImfile.exp_id = rawExp.exp_id
 LEFT JOIN camProcessedExp
     ON camRun.cam_id = camProcessedExp.cam_id