两表关联修改(匹配写入)

Posted on 2018-07-27 13:58  杭州丑八怪  阅读(156)  评论(0)  编辑  收藏  举报 
update  Lookchem20180726  set Lookchem20180726.pagetitle=dbo.P_CAS.P_CasNo  from  Lookchem20180726,dbo.P_CAS
where Lookchem20180726.Keyname=dbo.P_CAS.P_ProductNameCn