简单的SQL联表更新

UPDATE dbo.bankinfo1 SET bankinfo1.BankName=BankInfo.BankName
FROM BankInfo where bankinfo1.banknumber=bankinfo.banknumber

UPDATE a SET a.bankname=b.bankname
FROM dbo.bankinfo1 a
INNER JOIN dbo.BankInfo b ON a.BankNumber=b.BankNumber
WHERE a.BankName<>b.BankName