delete
from W02_CORP_GETMONEYAPPLY w
where w.ID in (select m.ID from M02_CORP_GETMONEYAPPLY m)
or w.GETMONEYAPPLYNO in
(select t.GETMONEYAPPLYNO from M02_CORP_GETMONEYAPPLY t)W02_CORP_GETMONEYAPPLY 这个表的ID主键,GETMONEYAPPLYNO有唯一约束
M02_CORP_GETMONEYAPPLY 这个表和W02_CORP_GETMONEYAPPLY的结构一样,不过没有主键也没有唯一约束上面的sql语句执行的很慢,各位高手看能不能优化一下,当然我要的不是把他拆成2个SQL语句,而是一个,高手帮忙啊!
from W02_CORP_GETMONEYAPPLY w
where w.ID in (select m.ID from M02_CORP_GETMONEYAPPLY m)
or w.GETMONEYAPPLYNO in
(select t.GETMONEYAPPLYNO from M02_CORP_GETMONEYAPPLY t)W02_CORP_GETMONEYAPPLY 这个表的ID主键,GETMONEYAPPLYNO有唯一约束
M02_CORP_GETMONEYAPPLY 这个表和W02_CORP_GETMONEYAPPLY的结构一样,不过没有主键也没有唯一约束上面的sql语句执行的很慢,各位高手看能不能优化一下,当然我要的不是把他拆成2个SQL语句,而是一个,高手帮忙啊!
delete
from W02_CORP_GETMONEYAPPLY w
where exists (select 1 from M02_CORP_GETMONEYAPPLY m where m.ID = w.ID or m.GETMONEYAPPLYNO = w.GETMONEYAPPLYNO )
delete from W02_CORP_GETMONEYAPPLY w where exists(select 1 from M02_CORP_GETMONEYAPPLY where w.ID=id or w.GETMONEYAPPLYNO=GETMONEYAPPLYNO)