这句sql语句该如何写_Sql Server

这句sql语句该怎么写？
update Hname as a,Hjit as b set a.Hzsname='wangxi',a.Hzhenjian='513822198610018832',[email protected]',a.Hdizhi='成都市温江区',a.Htel='13658020806',b.HJshouru='金卡手机费',b.HJshourulaiyuan='抢劫',b.HJname='呵呵',b.HJtel='26291478',b.HJguanxi='亲密',b.HJzhuzhi='四川眉山',b.HJyoubian='262914' where a.Id=b.Id and a.Id=1

------解决方案--------------------
where Id=b.Id and a.Id=1
改成 where a.Id=b.Id and a.Id=1

------解决方案--------------------
分开写：

SQL code

update Hname  set Hzsname='wangxi'    ,Hzhenjian='513822198610018832'    ,[email protected]'     ,Hdizhi='成都市温江区'     ,Htel='13658020806'from Hname  a ,Hjit  bwhere a.Id=b.Id and a.Id=1update Hjit set HJshouru='金卡手机费'    ,HJshourulaiyuan='抢劫'    ,HJname='呵呵'    ,HJtel='26291478'    ,HJguanxi='亲密'     ,HJzhuzhi='四川眉山'     ,HJyoubian='262914'     from Hname  a ,Hjit  bwhere a.Id=b.Id and a.Id=1
------解决方案--------------------
探讨
update Hname 
 set Hzsname='wangxi'
    ,Hzhenjian='513822198610018832'
    ,[email protected]'
     ,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',[email protected]',Hdizhi='成都市温江区',Htel='13658020806'from Hname as a,Hjit as b where a.Id=b.Id and a.Id=1update 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
------解决方案--------------------
发现个成都的