22,209
社区成员
发帖
与我相关
我的任务
分享
update a
set a.price=b.newprice
from tb1 a,tb2 b
where a.ppid=b.ppid
update t
set price = price+h.price
from price t join product r
on t.ppid=r.ppid join XX h
on r.ppcode=h.ppcode
update t
set ppid = r.ppcode
from price t join product r
on t.ppid=r.ppid
update a
set a.price=b.ppcode
from tb1 a,tb2 b
where a.ppid=b.ppid