⬅ Back MULTY DELETE SALE return del query.txt
use T22S001


delete from RECEIVED_RETURN_GOODS_ITEM_DETAIL where LEN (BkSrNo) =6 And BkSrNo > = '000010' and BkSrNo < = '012332'
delete from RECEIVED_RETURN_GOODS_TAKA_DETAIL where LEN (BkSrNo) =6 And BkSrNo > = '000010' and BkSrNo < = '012332'
delete from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where LEN (BkSrNo) =6 And BkSrNo > = '000010' and BkSrNo < = '012332'
delete from RECEIVED_RETURN_GOODS_DETAIL where LEN (BkSrNo) =6 And BkSrNo > = '000010' and BkSrNo < = '012332'