-- 查询
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)