Index: /trunk/ippTools/share/camtool_find_pendingimfile.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 19971)
+++ /trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 19972)
@@ -3,20 +3,6 @@
      -- which table the field came from
     (SELECT
-        camRun.*,
-        chipProcessedImfile.exp_id,
-        chipProcessedImfile.class_id,
-        chipProcessedImfile.uri,
-        chipProcessedImfile.bg,
-        chipProcessedImfile.bg_stdev,
-        chipProcessedImfile.bg_mean_stdev,
-        chipProcessedImfile.fringe_0,
-        chipProcessedImfile.fringe_1,
-        chipProcessedImfile.fringe_2,
-        chipProcessedImfile.ap_resid,
-        chipProcessedImfile.ap_resid_stdev,
-        chipProcessedImfile.n_stars,
-        chipProcessedImfile.n_extended,
-        chipProcessedImfile.n_cr,
-        chipProcessedImfile.path_base,
+        camRun.cam_id,
+        chipProcessedImfile.*,
         rawExp.exp_name,
         rawExp.camera,
@@ -25,9 +11,11 @@
     FROM camRun
     JOIN chipRun
-        USING(chip_id)
+--      ON camRun.chip_id = chipRun.chip_id
+        USING (chip_id)
     JOIN chipProcessedImfile
-        USING(chip_id)
+--      ON camRun.chip_id = chipProcessedImfile.chip_id
+        USING (chip_id)
     JOIN rawExp
-        ON chipProcessedImfile.exp_id = rawExp.exp_id
+      ON chipProcessedImfile.exp_id = rawExp.exp_id
     LEFT JOIN camProcessedExp
         USING(cam_id)