UPDATE T_FA_BALANCE SET FCUROPERATION = '0', FCUROPERATIONBILLNO = ''
WHERE FISNEWREC = '2'AND FASSETID =(
SELECT FASSETID FROM T_FA_CARD WHERE FALTERID =(
SELECT FALTERID FROM T_FA_CHANGE WHERE FBILLNO = '此处替换出问题的单号'))
UPDATE T_FA_BALANCE SET FCUROPERATION = '0', FCUROPERATIONBILLNO = ''
WHERE FISNEWREC = '2'AND FASSETID =(
SELECT FASSETID FROM T_FA_CARD WHERE FALTERID =(
SELECT FALTERID FROM T_FA_CHANGE WHERE FBILLNO = '此处替换出问题的单号'))