这句sql语句该如何写

这句sql语句该怎么写？
update Hname as a,Hjit as b set a.Hzsname='wangxi',a.Hzhenjian='513822198610018832',a.Hemail='156436856@qq.com',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'
    ,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

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

相关推荐