use T21P001

UPDATE RECEIVED_BANK_BOOK_DETAIL SET BkChequeAmt=T1.F1+BkTCSAmt FROM (SELECT SUM(BkBillPaidAmt) AS F1, BkSrNo AS F2 FROM RECEIVED_BANK_BOOK_ADDLESS_DETAIL GROUP BY BkSrNo) AS T1 WHERE T1.F2=BkSrNo
UPDATE RECEIVED_CASH_BOOK_DETAIL SET BkCashAmt=T1.F1+BkTCSAmt FROM (SELECT SUM(BkBillPaidAmt) AS F1, BkSrNo AS F2 FROM RECEIVED_CASH_BOOK_ADDLESS_DETAIL GROUP BY BkSrNo) AS T1 WHERE T1.F2=BkSrNo
UPDATE PAYMENT_BANK_BOOK_DETAIL SET BkChequeAmt=T1.F1+BkTCSAmt FROM (SELECT SUM(BkBillPaidAmt) AS F1, BkSrNo AS F2 FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL GROUP BY BkSrNo) AS T1 WHERE T1.F2=BkSrNo
UPDATE PAYMENT_CASH_BOOK_DETAIL SET BkCashAmt=T1.F1+BkTCSAmt FROM (SELECT SUM(BkBillPaidAmt) AS F1, BkSrNo AS F2 FROM PAYMENT_CASH_BOOK_ADDLESS_DETAIL GROUP BY BkSrNo) AS T1 WHERE T1.F2=BkSrNo