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

trunk/ippTools/share/camtool_find_processedexp.sql

@@ -1 +1 @@
 SELECT
     camProcessedExp.*,
+    rawExp.exp_id,
     rawExp.camera,
-    rawExp.workdir
+    rawExp.telescope,
+    rawExp.filelevel
 FROM camProcessedExp
 JOIN chipProcessedExp