Changeset 12259 for trunk/ippTools/share/regtool_processedimfile.sql

Timestamp:

Mar 5, 2007, 5:41:11 PM (19 years ago)

Author:

jhoblitt

Message:

split detselect SQL out into their own files
add rawExp.filelevel field

File:

• trunk/ippTools/share/regtool_processedimfile.sql (modified) (1 diff)

trunk/ippTools/share/regtool_processedimfile.sql

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