表A:ID, PRICEA
0001 10
0002 20
表B:ID, PRICEB
0001
0002
我想要的结果是:
表B:ID, PRICEB
0001 10
0002 20
------解决方案--------------------
- SQL code
update b set priceb=a.pricea from 表A a inner join 表B b on a.id=b.id
------解决方案--------------------
- SQL code
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
------解决方案--------------------
- SQL code
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