时空老数据删除语句

wbv123

delete from jxddhz
where djbh in ('JHFZDA10000430','JHZZDA10000420')
delete from jxddmx
where djbh in ('JHFZDA10000430','JHZZDA10000420')

delete from dhtz_hz where djbh in ('DHDZDA10000416')
delete from dhtz_mx where djbh in ('DHDZDA10000416')

delete from jh_djhz where djbh in ('JHGZDA10000424')
delete from jh_djmx where djbh in ('JHGZDA10000424')

delete from jh_rkhz where djbh in ('JHAZDA10000414')
delete from jh_rkmx where djbh in ('JHAZDA10000414')
delete from spls_rk where djbh in ('JHAZDA10000414')

delete from pf_djhz
where djbh in ('XSGZDA10001495','XSGZDA10001496','XSGZDA10001497')
delete from pf_djmx
where djbh in ('XSGZDA10001495','XSGZDA10001496','XSGZDA10001497')

delete from pf_ckhz
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')
delete from pf_ckmx
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')
delete from spls_ck
where djbh in ('XSAZDA10001493','XSAZDA10001494','XSAZDA10001495')

delete from jzorder_hz_his
where djbh in ('JHGZDA10000424','XSGZDA10001495',
'XSGZDA10001496','XSGZDA10001497')
delete from jzorder_mx_his
where djbh in ('JHGZDA10000424','XSGZDA10001495',
'XSGZDA10001496','XSGZDA10001497')

delete from mxysyf
where djbh in ('JHAZDA10000414','XSAZDA10001493',
'XSAZDA10001494','XSAZDA10001495')
delete from wlzhk
where djbh in ('JHAZDA10000414','XSAZDA10001493',
'XSAZDA10001494','XSAZDA10001495')

delete from fhjld
where djbh in ('FHAZDA10001493','FHAZDA10001494','FHAZDA10001495')
delete from fhjldmx
where djbh in ('FHAZDA10001493','FHAZDA10001494','FHAZDA10001495')