USE T21K001

DELETE FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE BKSTATUS='ON A/C' AND LEN(BKSRNO)=10
DELETE FROM RECEIVED_BANK_BOOK_DETAIL WHERE BKSRNO NOT IN (SELECT BKSRNO FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL WHERE LEN(BKSRNO)=10) AND LEN(BKSRNO)=10