Index: trunk/ippTools/share/diffphottool_input.sql
===================================================================
--- trunk/ippTools/share/diffphottool_input.sql	(revision 28343)
+++ trunk/ippTools/share/diffphottool_input.sql	(revision 28345)
@@ -1,6 +1,13 @@
 SELECT
     diffPhotRun.*,
-    diffSkyfile.path_base
+    diffSkyfile.path_base,
+    rawExp.camera
 FROM diffPhotRun
 JOIN diffRun USING(diff_id)
 JOIN diffSkyfile USING(diff_id)
+JOIN diffInputSkyfile USING(diff_id, skycell_id)
+JOIN warpRun ON warp1 = warp_id -- only JOINing on input warps!
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
