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

trunk/ippTools/share/chiptool_processedimfile.sql

@@ -7 +7 @@
     chipProcessedImfile.bg_mean_stdev,
     chipProcessedImfile.path_base,
-    rawExp.exp_id,
+    rawExp.exp_name,
     rawExp.camera,
     rawExp.telescope,
@@ -15 +15 @@
     USING(chip_id)
 JOIN rawExp
-    ON chipProcessedExp.exp_tag = rawExp.exp_tag
+    ON chipProcessedExp.exp_id = rawExp.exp_id
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too
-    chipProcessedImfile.exp_tag is NOT NULL
+    chipProcessedImfile.exp_id is NOT NULL