刪除存貨刪除不了

問題回復(fù)：

--庫存期初后端可以查到 沒有倉庫的不符合業(yè)務(wù)規(guī)則的數(shù)據(jù) --刪除這些數(shù)據(jù)即可（與伙伴已溝通，T1升級的數(shù)據(jù)） 

select ST_RDRecord_b.* into ST_RDRecord_temp from ST_RDRecord inner join ST_RDRecord_b on ST_RDRecord.id =ST_RDRecord_b.idRDRecordDTO where idvouchertype in (select id from sm_vouchertype where name ='庫存期初') and ST_RDRecord_b.idwarehouse is null and ST_RDRecord.idwarehouse is null delete from ST_RDRecord_b where id in (select id from ST_RDRecord_temp) delete from ST_RDRecord where id in (select idRDRecordDTO from ST_RDRecord_temp)