UPDATE BILL_ITEM_DETAIL Set PurSrNo = T1.F3 FROM (
SELECT BILL_ITEM_DETAIL.BillNo AS F1, BILL_ITEM_DETAIL.ItemSrNo AS F2, FINISHED_PURCHASE.SrNo AS F3 FROM BILL_ITEM_DETAIL INNER JOIN FINISHED_PURCHASE ON BILL_ITEM_DETAIL.Supplier = FINISHED_PURCHASE.WeaverCode AND BILL_ITEM_DETAIL.ItemSerialNo = FINISHED_PURCHASE.BillNo
) AS T1 WHERE T1.F1 COLLATE DATABASE_DEFAULT = BillNo AND T1.F2 = ItemSrNo

UPDATE FINISHED_PURCHASE_ITEM_DETAIL Set ItemBillNo = T1.F1, ItemBISrNo = ISrNo FROM (
SELECT BILL_ITEM_DETAIL.BillNo AS F1, BILL_ITEM_DETAIL.ItemSrNo AS F2, FINISHED_PURCHASE.SrNo AS F3 FROM BILL_ITEM_DETAIL INNER JOIN FINISHED_PURCHASE ON BILL_ITEM_DETAIL.Supplier = FINISHED_PURCHASE.WeaverCode AND BILL_ITEM_DETAIL.ItemSerialNo = FINISHED_PURCHASE.BillNo
) AS T1 WHERE T1.F3 COLLATE DATABASE_DEFAULT = SrNo