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

trunk/ippTools/share/camtool_find_processedexp.sql

@@ -1 +1 @@
 SELECT
     camProcessedExp.*,
-    rawExp.exp_id,
+    rawExp.exp_name,
     rawExp.camera,
     rawExp.telescope,
@@ -9 +9 @@
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_tag = rawExp.exp_tag
+    ON chipProcessedExp.exp_id = rawExp.exp_id
 WHERE -- bogus condition so there is a pre-existing where to append to
     camProcessedExp.cam_id IS NOT NULL