sql server 中两个关联表之间更新数据

最新推荐文章于 2023-11-12 18:43:09 发布

weixin_34303897

最新推荐文章于 2023-11-12 18:43:09 发布

阅读量241

点赞数

原文链接：http://www.cnblogs.com/tollin/archive/2012/11/28/2792773.html

版权

环境: sql server 2008 r2

不废话了，上sql

UPDATE dbo.Emp_BasicInfoRegister SET dbo.Emp_BasicInfoRegister.HasPhoto = dbo.Emp_BasicInfo.HasPhoto
, dbo.Emp_BasicInfoRegister.PhotoName = dbo.Emp_BasicInfo.PhotoName
FROM dbo.Emp_BasicInfo
WHERE dbo.Emp_BasicInfo.CardNo = dbo.Emp_BasicInfoRegister.CardNo
AND dbo.Emp_BasicInfo.Name = dbo.Emp_BasicInfoRegister.Name

转载于:https://www.cnblogs.com/tollin/archive/2012/11/28/2792773.html