Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 37122)
+++ trunk/ippTools/share/Makefile.am	(revision 37131)
@@ -487,4 +487,5 @@
 	releasetool_deleterelstack.sql \
 	releasetool_listrelstack.sql \
+	releasetool_setrelstackcalibratedfromskycal.sql 
 	releasetool_summary.sql \
 	releasetool_definerelgroup_select_lap.sql \
Index: trunk/ippTools/share/releasetool_setrelstackcalibratedfromskycal.sql
===================================================================
--- trunk/ippTools/share/releasetool_setrelstackcalibratedfromskycal.sql	(revision 37131)
+++ trunk/ippTools/share/releasetool_setrelstackcalibratedfromskycal.sql	(revision 37131)
@@ -0,0 +1,11 @@
+UPDATE relStack
+    JOIN ippRelease USING(rel_id)
+    JOIN skycell USING(tess_id, skycell_id)
+    JOIN stackRun USING(stack_id, tess_id, skycell_id)  
+    JOIN skycalRun USING(stack_id)  -- join to skycal using stack_id not skycal_id ...
+    JOIN skycalResult ON skycalRun.skycal_id = skycalResult.skycal_id
+SET relStack.skycal_id = skycalRun.skycal_id,    -- ... because we set skycal_id here
+    relStack.zpt_obs = skycalResult.zpt_obs,
+    relStack.zpt_stdev = skycalResult.zpt_stdev,
+    relStack.state = 'calibrated'
+WHERE relStack.state = 'processed'