SqlServer根据一个表更新另一个表数据

--根据B更新A
UPDATE a SET a.RecordId=b.RecordId FROM dbo.Z_InternalContract_RecordAttachment a JOIN dbo.T_InternalContract_Record b ON a.Old_RecordId=b.Old_RecordId