Index: branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_defineforstacks.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_defineforstacks.sql	(revision 42587)
+++ 	(revision )
@@ -1,14 +1,0 @@
-SELECT
-    xccalRun.xccal_id,
-    xccalResult.path_base,
-    xccalRun.data_group,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    stackRun.filter
-FROM xccalRun
-    JOIN xccalResult USING(xccal_id)
-    JOIN stackRun USING(stack_id)
-    JOIN skycell USING(tess_id, skycell_id)
-    -- join hook %s
-WHERE 
-    xccalRun.state = 'full' AND xccalResult.quality = 0
Index: branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_defineforstacks_select_warps.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_defineforstacks_select_warps.sql	(revision 42587)
+++ 	(revision )
@@ -1,5 +1,0 @@
-SELECT warp_id
-FROM stackInputSkyfile
-     JOIN stackRun USING (stack_id)
-     JOIN xccalRun USING (stack_id)
-WHERE xccal_id = '%d'
Index: branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_updaterun.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_updaterun.sql	(revision 42591)
+++ branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_updaterun.sql	(revision 42591)
@@ -0,0 +1,7 @@
+UPDATE xcForceRun
+JOIN %s.xccalRun            USING(xccal_id)
+JOIN %s.xccalResult         USING (xccal_id)
+JOIN %s.xcstackInputSkyfile USING (xcstack_id) -- exposes the stack_id
+JOIN %s.xcstackCamera       USING (camera_id) -- select the camera matching this db
+JOIN stackRun               USING (stack_id)
+JOIN skycell USING(tess_id, skycell_id)");