Index: trunk/ippTools/share/camtool_find_chip_id.sql
===================================================================
--- trunk/ippTools/share/camtool_find_chip_id.sql	(revision 14147)
+++ trunk/ippTools/share/camtool_find_chip_id.sql	(revision 14227)
@@ -1,11 +1,31 @@
--- 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