Index: trunk/ippTools/share/staticskytool_skycalresult.sql
===================================================================
--- trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 34974)
+++ trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 34975)
@@ -2,13 +2,12 @@
     skycalResult.*,
     skycalRun.stack_id,
-    stackRun.tess_id,
-    stackRun.skycell_id,
     stackRun.filter,
     skycalRun.state,
     skycalRun.label,
     skycalRun.data_group,
-    skycalRun.sky_id
+    skycalRun.sky_id,
+    skycell.*
 FROM skycalRun
 JOIN skycalResult USING(skycal_id)
-JOIN stackRun USING(stack_id)
-
+JOIN stackRun USING(stack_id) 
+JOIN skycell USING(tess_id, skycell_id)