日期:2014-05-17 浏览次数:20569 次
update table1 set b.kucun=a.shuliang from table1 b,table2 a where b.name=a.t2name
------解决方案--------------------
update table1 set kucun=(select u.shuliang from table1 d,table2 u where d.name=u.t2name)
------解决方案--------------------
UPDATE a SET a.kucun = b.shuliang FROM table1 a INNER JOIN table2 b ON a.NAME = b.NAME