Update loupan a Set zhandimianji ( Select zzdmj From test b Where b.keyword = a.loupanname);
Update loupan a Set zhandimianji = ( Select zzdmj From test b Where b.keyword = a.loupanname);
--ORACLE 要根据两额表更新有好几种方法--类似这个应该可以 update loupan lp set lp.zhandimianji = (select zzdmj from test t where t.keyword = lp.loupanname) where exists (select 1 from test t where t.keyword = lp.loupanname)--这种方法是比较多人用的
update a
set a.zhandimianji=b.zzdmj
from loupan a,test b
where a.loupanname=b.keyword
这个写法是SQL SERVER的语法。在ORACLE也有类似的语法,不过ORACLE有个条件限制,应该是两表的关联字段必须为主键
Select zzdmj From test b Where b.keyword = a.loupanname);
Select zzdmj From test b Where b.keyword = a.loupanname);
--ORACLE 要根据两额表更新有好几种方法--类似这个应该可以
update loupan lp
set lp.zhandimianji = (select zzdmj
from test t
where t.keyword = lp.loupanname)
where exists (select 1 from test t where t.keyword = lp.loupanname)--这种方法是比较多人用的