update tmp t set t.name=(select t2.name from tmp2 t2 where t2.idcard=t.idcard)
where exist (select 1 from tmp2 t2 where t2.idcard=t.idcard)
转载于:https://my.oschina.net/u/2336787/blog/486241
update tmp t set t.name=(select t2.name from tmp2 t2 where t2.idcard=t.idcard)
where exist (select 1 from tmp2 t2 where t2.idcard=t.idcard)
转载于:https://my.oschina.net/u/2336787/blog/486241