CREATE TABLE Tmp_FinSrDetail (SrNo Varchar(255))
insert into Tmp_FinSrDetail select SrNo from FINISHED_PURCHASE where billno='0.00'

Delete From FINISHED_PURCHASE_TAKA_DETAIL Where SrNo IN (SELECT SRNO FROM Tmp_FinSrDetail)
Delete From FINISHED_PURCHASE_ITEM_DETAIL Where SrNo IN (SELECT SRNO FROM Tmp_FinSrDetail)
Delete From FINISHED_PURCHASE Where SrNo IN (SELECT SRNO FROM Tmp_FinSrDetail)
Delete From FIRM_ADDLESS_DETAIL WHERE Formname='FINISHED PURCHASE' AND formSrNo IN (SELECT SRNO FROM Tmp_FinSrDetail)