update Hname 
 set Hzsname='wangxi'
    ,Hzhenjian='513822198610018832'
    ,Hemail='156436856@qq.com'
     ,Hdizhi='成都市温江区'
     ,Htel='13658020806'
from Hname  a ,Hjit  b
where a.Id=b.Id and a.Id=1

update Hjit 
set HJshouru='金卡手机费'
    ,HJshourulaiyuan='抢劫'
    ,HJname='呵呵'
    ,HJtel='26291478'
    ,HJguanxi='亲密'
     ,HJzhuzhi='四川眉山'
     ,HJyoubian='262914' 
    from Hname  a ,Hjit  b
where a.Id=b.Id and a.Id=1

------解决方案--------------------
探讨

update Hname 
 set Hzsname='wangxi'
    ,Hzhenjian='513822198610018832'
    ,Hemail='156436856@qq.com'
     ,Hdizhi='成都市温江区'
     ,Htel='13658020806'
from Hname  a ,Hjit  b
where a.Id=b.Id and a.Id=1

update Hjit 
set HJshouru='金卡手机费'
    ,HJshourulaiyuan='抢劫'
    ,HJname='呵呵'
    ,HJtel='26291478'
    ,HJguanxi='亲密'
     ,HJzhuzhi='四川眉山'
     ,HJyoubian='262914' 
    from Hname  a ,Hjit  b
where a.Id=b.Id and a.Id=1


------解决方案--------------------
SQL code
用

update Hname set Hzsname='wangxi',Hzhenjian='513822198610018832',Hemail='156436856@qq.com',Hdizhi='成都市温江区',Htel='13658020806'
from Hname as a,Hjit as b where a.Id=b.Id and a.Id=1

update Hjit set HJshouru='金卡手机费',HJshourulaiyuan='抢劫',HJname='呵呵',HJtel='26291478',HJguanxi='亲密',HJzhuzhi='四川眉山',HJyoubian='262914' 
from Hname as a,Hjit as b where a.Id=b.Id and a.Id=1

------解决方案--------------------
发现个成都的