update aa set SearchText = bb.searchtext from dbo.TScenery aa inner join
(select a.ID,d.Province+' '+c.City+' '+b.Area+' '+a.SceneryName+' '+
dbo.FGetAllType(a.ID) searchtext from dbo.TScenery a
INNER join dbo.TArea b on a.Area = b.AreaID
INNER join dbo.TCity c on b.CityID = c.CityID
INNER join dbo.TProvince d on d.ProvinceID=c.ProvinceID ) bb
on aa.ID = bb.ID
