[概述]

t_fabalance表中fnump字段异常,需执行语句批量修改。

参考语句:

update a set a.FNumP=b.FNum-a.FNumAlter

--select FNumP,b.FNum,fnumalter,*

from t_FABalance a join t_FABalCard b on a.FBalID=b.FBalID where a.FNumP+a.FNumAlter<>b.Fnum

[注意]

执行语句前请备份好账套。