应收冲应付删除不掉的后台处理

wizardzhou

和懂财务又懂SQL的人交流，其他人看不懂就算了 （有问题的图片，不知道帖上去）

select * from t_rp_contact where fnumber in ('PPOFP000774','QTYS000185','QTYS000182')

select * from t_rp_contact where fdate='2010-01-31'

select * from t_rp_contact where fid>=12209 and fid<=12214

select * from t_rp_contact where fnumber in ('PPOFP000774','QTYS000185','QTYS000182','QTYF000247','OXPP000697','QTYF000247','PSEFP003247','QTYF000245','PSEFP003247')

DELETE FROM T_RP_CONTACT WHERE FID IN (12209,12210,12211,12212,12213,12214)

wizardzhou

回复 1# wizardzhou


    是呀，你可以备份一个帐套测试