34,593
社区成员
发帖
与我相关
我的任务
分享
update t1 set price=b.price from A t1 inner join B on t1.id=b.id
update a set a.Price=b.Price
from 表A a,表B b where a.id=b.id
update t1 set price=t2.price from 表A t1 inner join 表B t2 on t1.id=t2.id
where t1.price<>t2.price
update t1 set price=t2.price from 表A t1 inner join 表B t2 on t1.id=t2.id