34,594
社区成员
发帖
与我相关
我的任务
分享
update p set p.Price=pp.Price
from PtypePrice as p
inner join PtypePrice as pp on pp.Ptypeid=p.Ptypeid
where p.PriceTypeid='CKCB' and pp.PriceTypeid='YSCGJ1'
谢谢大家,也特别感谢1楼已解决。UPDATE T2
SET Price = T1.Price
FROM PtypePrice AS T1,PtypePrice AS T2
WHERE T1.PriceTypeid = 'YSCGJ1'
AND T2.PriceTypeid = 'CKCB'
AND T1.Ptypeid = T2.Ptypeid
UPDATE PtypePrice
SET Price = PtypePrice.Price
FROM PtypePrice
WHERE PtypePrice.PriceTypeid = 'YSCGJ1'
AND PtypePrice.PriceTypeid = 'CKCB'
AND PtypePrice.Ptypeid = PtypePrice.Ptypeid
UPDATE T2
SET Price = T1.Price
FROM T1
WHERE T1.PriceTypeid = 'YSCGJ1'
AND T2.PriceTypeid = 'CKCB'
AND T1.Ptypeid = T2.Ptypeid;
update p set p.Price=pp.Price
from price as p
inner join price as pp on pp.Ptypeid=p.Ptypeid
where p.PriceTypeid='CKCB' and pp.PriceTypeid='YSCGJ1'