费用参考语句

admin

费用明细语句参考
select * from YW_ZY_JZ_ZY where yybm='004' and zyh='20190912' and  rq>'2019-11-01 8:59:59.000'

select * from  YW_YF_CKDMX_ZY where yybm='004' and zyh='20190912' and rq>='2019-11-01 8:59:59.000'

update YW_YF_CKDMX_ZY set rq= '2019-11-01 8:59:59.000' where yybm='004' and zyh='20190912' and rq>= '2019-11-01 8:59:59.000'

update YW_ZY_JZ_ZY set rq= '2019-11-01 8:59:59.000' where yybm='004' and zyh='20190912' and rq>= '2019-11-01 8:59:59.000'

admin

+1