Changeset 14227 for trunk/ippTools/share/camtool_find_chip_id.sql

Timestamp:

Jul 16, 2007, 11:56:49 AM (19 years ago)

Author:

jhoblitt

Message:

update camtool -queue

File:

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

trunk/ippTools/share/camtool_find_chip_id.sql

@@ -1 @@
--- this query is used by both camtool -pendingexp & camtool -addprocessedexp it
--- does a little more work then is necessary for -addprocessed but it seems
--- "cleaner" to use the same query for both cases 
 SELECT
     *
 FROM
     (SELECT DISTINCT
-        chipRun.*
+        chipRun.*,
+        rawExp.camera,
+        rawExp.telescope,
+        rawExp.dateobs,
+        rawExp.exp_tag,
+        rawExp.exp_type,
+        rawExp.filelevel,
+        rawExp.filter,
+        rawExp.airmass,
+        rawExp.ra,
+        rawExp.decl,
+        rawExp.exp_time,
+        rawExp.sat_pixel_frac,
+        rawExp.bg,
+        rawExp.bg_stdev,
+        rawExp.bg_mean_stdev,
+        rawExp.alt,
+        rawExp.az,
+        rawExp.ccd_temp,
+        rawExp.posang,
+        rawExp.object,
+        rawExp.solang
     FROM chipRun
+    JOIN rawExp
+        using(exp_id)
     WHERE
         chipRun.state = 'stop') as Foo