Index: trunk/ippTools/share/faketool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/faketool_pendingimfile.sql	(revision 17938)
+++ trunk/ippTools/share/faketool_pendingimfile.sql	(revision 18029)
@@ -21,5 +21,6 @@
         chipProcessedImfile.n_cr,
         chipProcessedImfile.n_astrom,
-        chipProcessedImfile.path_base,
+        chipProcessedImfile.path_base as chip_path_base,
+        camProcessedExp.path_base as cam_path_base,
         rawExp.exp_name,
         rawExp.camera,
@@ -28,4 +29,6 @@
     FROM fakeRun
     JOIN camRun
+        USING(cam_id)
+    JOIN camProcessedExp
         USING(cam_id)
     JOIN chipRun