Changeset 14023 for trunk/ippTools/share/regtool_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/regtool_processedimfile.sql (modified) (1 diff)

trunk/ippTools/share/regtool_processedimfile.sql

@@ -1 +1 @@
 SELECT
     rawImfile.*,
-    newExp.exp_id,
+    newExp.exp_name,
     newExp.camera,
     newExp.telescope
 FROM rawImfile
 JOIN newExp
-    USING(exp_tag)
+    USING(exp_id)
 -- bogus conditional so there is a where clause to append to
-WHERE rawImfile.exp_tag is NOT NULL
+WHERE rawImfile.exp_id is NOT NULL