--查询总账科目
select * from t_Account where fnumber = '1002.31'
--查询现金科目
select *
--delete a
--update a set a.fkmid = 1845,fkmdm = '1002.31'
from cn_account a where fid = 53 or fid = 51
--查询现金科目对应的日记账
select * from cn_xjrjz where fkmid in (51,53)--现金日记账
select * from cn_yhrjz where fkmid in (51,53)--银行日记账
--查询现金科目对应的期初余额
select * --delete
from cn_lcye where fkmid = 53 or fkmid = 52