摘要： 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.Ci 阅读全文