需求：如果表1的ID等于表2的ID，将表1的Name更新为表2的Name
update [表1]
inner join [表2]
on [表1].[ID] = [表2].[ID]
set [Name] = [表2].[Name]
on [表1].[ID] = [表2].[ID]
set [Name] = [表2].[Name]
3849
评论 1
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
