如果是sqlserver update t_bscj set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh
如果是sqlserver update t_bscj set xm=b.xm ,sfzh=b.sfzh,zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh
来迟了,可惜,顺手写一段吧 update a set a.xm=b.xm,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh 楼主别忘了多散点分给我哦,呵~~~ 进了这一行业,变穷了
或者 update a set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a inner join t_ybm b on a.wbbh=b.wbbh
复制一下: update a set a.xm=b.xm,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh
如果是sqlserver update t_bscj set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh这是1楼的答案如果是sqlserver update t_bscj set xm=b.xm ,sfzh=b.sfzh,zkzh=b.zkzh from t_bscj a,t_ybm b where a.wbbh=b.wbbh这是2楼的答案 谁能告诉我为什么1楼的不对
update t_bscj set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b
where a.wbbh=b.wbbh
update t_bscj set xm=b.xm ,sfzh=b.sfzh,zkzh=b.zkzh from t_bscj a,t_ybm b
where a.wbbh=b.wbbh
update a set a.xm=b.xm,a.sfzh=b.sfzh,a.zkzh=b.zkzh
from t_bscj a,t_ybm b
where a.wbbh=b.wbbh
楼主别忘了多散点分给我哦,呵~~~
进了这一行业,变穷了
update a set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a inner join t_ybm b on a.wbbh=b.wbbh
update a set a.xm=b.xm,a.sfzh=b.sfzh,a.zkzh=b.zkzh
from t_bscj a,t_ybm b
where a.wbbh=b.wbbh
update t_bscj set a.xm=b.xm ,a.sfzh=b.sfzh,a.zkzh=b.zkzh from t_bscj a,t_ybm b
where a.wbbh=b.wbbh这是1楼的答案如果是sqlserver
update t_bscj set xm=b.xm ,sfzh=b.sfzh,zkzh=b.zkzh from t_bscj a,t_ybm b
where a.wbbh=b.wbbh这是2楼的答案 谁能告诉我为什么1楼的不对