use T21G001

drop table T21G001.DBO.BANK_DATA 

CREATE TABLE T21G001.DBO.BANK_DATA (BkSrNo Varchar(10), PaidAmt Money, OrgSrNo Varchar(10))
insert into T21G001.DBO.BANK_DATA SELECT Right(BkSrNo,6), BkgrAmt, BkSrNo FROM T21G001.DBO.RECEIVED_RETURN_GOODS_detail WHERE LEN(BKSRNO)=10
alter table T21G001.DBO.BANK_DATA Add OrgPaidAmt Money

UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=0
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkGRAmt AS F1, BkSrNo AS F2 FROM T18G001.DBO.RECEIVED_RETURN_GOODS_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1718'
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkGRAmt AS F1, BkSrNo AS F2 FROM T19G001.DBO.RECEIVED_RETURN_GOODS_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1819'
UPDATE T21G001.DBO.BANK_DATA SET ORGPAIDAMT=T1.F1 FROM (SELECT BkGRAmt AS F1, BkSrNo AS F2 FROM T20G001.DBO.RECEIVED_RETURN_GOODS_DETAIL) AS T1 WHERE T1.F2 COLLATE DATABASE_DEFAULT = BkSrNo AND left(OrgSrNo,4)='1920'

SELECT * FROM T21G001.DBO.BANK_DATA WHERE orgpaidamt<>paidamt