UPDATE PAYMENT_BANK_BOOK_ADDLESS_DETAIL SET BkStatus = 'ON A/C' FROM (
SELECT PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo AS F1 FROM PAYMENT_BANK_BOOK_ADDLESS_DETAIL INNER JOIN PAYMENT_BANK_BOOK_DETAIL ON PAYMENT_BANK_BOOK_DETAIL.BkSrNo = PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkSrNo WHERE (PAYMENT_BANK_BOOK_ADDLESS_DETAIL.BkStatus = 'UN ADJ')
) AS T1 WHERE (BkStatus = 'UN ADJ') AND T1.F1 = BkSrNo


UPDATE MULTI_JOURNAL_ADDLESS_DETAIL SET BkStatus = 'ON A/C' FROM (
SELECT MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo AS F1 FROM MULTI_JOURNAL_ADDLESS_DETAIL INNER JOIN MULTI_JOURNAL_DETAIL ON MULTI_JOURNAL_DETAIL.BkSrNo = MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo WHERE (MULTI_JOURNAL_ADDLESS_DETAIL.BkStatus = 'UN ADJ')
) AS T1 WHERE (BkStatus = 'UN ADJ') AND T1.F1 = BkSrNo