Написать функцию, которая бы пробегала по всем записям одной таблицы и заносила бы их id в запрос на место Х

SELECT SUM(vvalue) FROM t_units WHERE ntypeid=Y AND vinout='OUTGOING' AND nnumberid=Х

WHERE fld1 IN
  (SELECT id
   FROM tab2
  )

WHERE fld1 IN (1, 5, 27)

SELECT n.vnumber, t.vname, t.noutfavoritecost, noutsystemcost, noutothercost, noutcityphonecost, noutinternationalcost, nsmscost, nmmscost, nwapcost FROM t_numbers n   
FULL JOIN t_contract c 
FULL JOIN t_tariff t ON c.ntariffid=t.id
ON c.id=n.ncontractid
GROUP BY n.vnumber, t.noutfavoritecost, t.vname, noutsystemcost, noutothercost, noutcityphonecost, noutinternationalcost, nsmscost, nmmscost, nwapcost

SELECT n.vnumber, t.vname, SUM(c.vvalue) FROM t_numbers n   
FULL JOIN t_units c 
FULL JOIN t_unittype t ON c.ntypeid=t.id
ON c.nnumberid=n.id
WHERE vinout='OUTGOING'
GROUP BY n.vnumber, t.vname

SELECT n.vnumber, t.vname, SUM(c.nvalue) FROM t_numbers n    
FULL JOIN t_cashactions c 
FULL JOIN t_cashactiontype t ON c.ncashactiontypeid=t.id
ON c.nnumberid=n.id
GROUP BY n.vnumber, t.vname

UPDATE t_numbers SET nbalance =  (Х*Y+Z) WHERE id=res.nnumberid;