Index: trunk/ippTools/share/difftool_todiffskyfile.sql
===================================================================
--- trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 17401)
+++ trunk/ippTools/share/difftool_todiffskyfile.sql	(revision 17713)
@@ -3,5 +3,6 @@
     diffRun.workdir,
     diffRun.skycell_id,
-    diffRun.tess_id
+    diffRun.tess_id,
+    rawExp.camera
 FROM diffRun
 JOIN diffInputSkyfile
@@ -11,4 +12,12 @@
     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
     AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
+JOIN warpRun
+    ON warpRun.warp_id = warpSkyfile.warp_id
+JOIN camRun
+    USING(cam_id)
+JOIN chipRun
+    USING(chip_id)
+JOIN rawExp
+    USING(exp_id)
 LEFT JOIN diffSkyfile
     ON diffInputSkyfile.diff_id = diffSkyfile.diff_id
@@ -16,3 +25,2 @@
   diffRun.state = 'run'
   AND diffSkyfile.diff_id IS NULL
-