让两个表中的数据同步

[baq925127]

update shopping_staticpageinfo spi
set spi.unitprice=mp.currentsaleprice
from shopping_staticpageinfo spi inner join shopping_markprice mp on spi.typeid = mp.marktypeid and spi.unitprice-mp.currentsaleprice!=0

我想判断当mp里面的商品和spi里面的商品一样，mp里面的价格和spi里面的价格不等，那么就让他们相等。SQL怎么写

[iqlife]

update shopping_staticpageinfo spi
set spi.unitprice
=(select mp.currentsaleprice from shopping_markprice mp
where spi.typeid = mp.marktypeid and spi.unitprice-mp.currentsaleprice!=0)

[Phoenix_99]

update shopping_staticpageinfo spi
set spi.unitprice
=(select mp.currentsaleprice from shopping_markprice mp   
where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice

[qin_phoenix]

update shopping_staticpageinfo spi
set spi.unitprice
=(select mp.currentsaleprice from shopping_markprice mp   
where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice)
where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice

[qin_phoenix]

[Quote=引用 3 楼 qin_phoenix 的回复:]
SQL code

update shopping_staticpageinfo spi
set spi.unitprice
=(select mp.currentsaleprice from shopping_markprice mp
where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice)
……
[/Quote]

update shopping_staticpageinfo spi
set spi.unitprice
=(select mp.currentsaleprice from shopping_markprice mp
where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice)
where exist (select 1 from shopping_markprice mp where spi.typeid = mp.marktypeid and spi.unitprice<>mp.currentsaleprice)

[qin_phoenix]

UPDATE SHOPPING_STATICPAGEINFO SPI
   SET SPI.UNITPRICE = (SELECT MP.CURRENTSALEPRICE
                          FROM SHOPPING_MARKPRICE MP
                         WHERE SPI.TYPEID = MP.MARKTYPEID
                           AND SPI.UNITPRICE <> MP.CURRENTSALEPRICE)
 WHERE EXISTS
 (SELECT 1
          FROM SHOPPING_MARKPRICE MP SPI.TYPEID = MP.MARKTYPEID AND SPI.UNITPRICE <> MP.CURRENTSALEPRICE)