日期:2014-05-18 浏览次数:20543 次
update b set priceb=a.pricea from 表A a inner join 表B b on a.id=b.id
------解决方案--------------------
update b set PRICEB=a.PRICEA from a join b on a.id=b.id
------解决方案--------------------
update b set PRICEB=a.PRICEA from a , b where a.id=b.id
------解决方案--------------------
update b set priceb=a.pricea from 表A a inner join 表B b on a.id=b.id
------解决方案--------------------
update b set PRICEB=a.PRICEA from a , b where a.id=b.id