Index: trunk/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_processedimfile.sql	(revision 12215)
+++ trunk/ippTools/share/chiptool_processedimfile.sql	(revision 12226)
@@ -1,13 +1,18 @@
 SELECT
-    chipProcessedImfile.*,
-    rawExp.camera,
-    rawExp.exp_tag,
+    chipProcessedExp.*,
+    chipProcessedImfile.class_id,
+    chipProcessedImfile.uri,
+    chipProcessedImfile.bg,
+    chipProcessedImfile.bg_stdev,
+    chipProcessedImfile.bg_mean_stdev,
+    chipProcessedImfile.path_base,
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope,
-    rawExp.workdir
+    rawExp.telescope
 FROM chipProcessedImfile
+JOIN chipProcessedExp
+    USING(chip_id)
 JOIN rawExp
-    USING(exp_tag)
+    ON chipProcessedExp.exp_tag = rawExp.exp_tag
 WHERE
 -- bogus test; just here so there there is a 'WHERE' stmt to append conditionals too