Index: /trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- /trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12225)
+++ /trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 12226)
@@ -1,9 +1,9 @@
 SELECT
-    chipPendingImfile.*,
-    rawExp.exp_tag,
+    chipPendingExp.*,
+    chipPendingImfile.class_id,
+    chipPendingImfile.uri,
     rawExp.exp_id,
     rawExp.camera,
-    rawExp.telescope,
-    rawExp.workdir
+    rawExp.telescope
 FROM chipPendingImfile
 JOIN chipPendingExp
Index: /trunk/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- /trunk/ippTools/share/chiptool_processedimfile.sql	(revision 12225)
+++ /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