将相关单据的pf_ckhx中的is_zx更新为否,再删除xshz_mx和xshz_hx中的相关数据
update pf_ckhz set is_zx='否' where djbh in ('XSAYMA00036212','XSAYMA00036208','XSAYMA00036211','XSAYMA00036209','XSAYMA00036210')
delete xshz_mx where djbh in ('XHZYMA00023714','XHZYMA00023712','XHZYMA00023710','XHZYMA00023711','XHZYMA00023709')
delete xshz_hz where djbh in ('XHZYMA00023714','XHZYMA00023712','XHZYMA00023710','XHZYMA00023711','XHZYMA00023709')
转载于:https://blog.51cto.com/bks2015/1745876