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

update  Lookchem20180726  set Lookchem20180726.pagetitle=dbo.P_CAS.P_CasNo  from  Lookchem20180726,dbo.P_CAS
where Lookchem20180726.Keyname=dbo.P_CAS.P_ProductNameCn