用一张表更新另一张表(做个标记)

-- 查询
select
    *
from
    AreaDishes20101015002 a
inner join
    Dishes b
    on a.DishesID=b.DishesID
inner join
(
    select 品名 as dn,调整后售价 as prc,目前售价 as nprc from dbo.[菌说炒菜调价1] union
    select 品名 as dn,调整后售价 as prc,目前售价 as nprc from dbo.[菌说炒菜调价$]
) c
    on b.DishesName=c.dn and c.nprc=convert(int,replace(a.Price,'￥',''))
where
    a.Price<>'时价' and a.AreaID in(23,24)

-- 更新
update a set
    a.Price= '￥'+convert(varchar(5),c.prc)
from
    AreaDishes20101015002 a
inner join
    Dishes b
    on a.DishesID=b.DishesID
inner join
(
    select 品名 as dn,调整后售价 as prc,目前售价 as nprc from dbo.[菌说炒菜调价1] union
    select 品名 as dn,调整后售价 as prc,目前售价 as nprc from dbo.[菌说炒菜调价$]
) c
    on b.DishesName=c.dn and c.nprc=convert(int,replace(a.Price,'￥',''))
where
    a.Price<>'时价' and a.AreaID in(23,24)