Index: trunk/ippTools/share/magictool_chipprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/magictool_chipprocessedimfile.sql	(revision 20701)
+++ trunk/ippTools/share/magictool_chipprocessedimfile.sql	(revision 20706)
@@ -3,5 +3,6 @@
     class_id,
     chipProcessedImfile.uri,
-    chipProcessedImfile.path_base
+    chipProcessedImfile.path_base,
+    camProcessedExp.path_base as cam_path_base
 FROM magicRun
 JOIN magicInputSkyfile USING(magic_id)
@@ -19,4 +20,5 @@
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
 JOIN chipProcessedImfile USING(chip_id,class_id)
Index: trunk/ippTools/share/magictool_rawimfile.sql
===================================================================
--- trunk/ippTools/share/magictool_rawimfile.sql	(revision 20701)
+++ trunk/ippTools/share/magictool_rawimfile.sql	(revision 20706)
@@ -2,5 +2,6 @@
     exp_id,
     class_id,
-    rawImfile.uri
+    rawImfile.uri,
+    camProcessedExp.path_base as cam_path_base
 FROM magicRun
 JOIN magicInputSkyfile USING(magic_id)
@@ -17,4 +18,5 @@
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
+JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id,exp_id)
 JOIN rawExp USING(exp_id)