SELECT info.ShopID, info.AreaID, info.Name, info.VehicleInfo, info.OrderNo, info.Tel, info.Tag, info.Address, info.Description, info.RecommendInfo,
info.ShopMap, info.ImagePath, info.OriginalPrice, info.SalePrice, info.ImageName, info.CreateTime, info.IsRecommend, g.avgvalue,
dbo.School.SchoolName, dbo.ShopType.TypeName, dbo.ShopType.ParentID, info.SchoolID, dbo.ShopType.TypeID
FROM dbo.ShopInfo AS info LEFT OUTER JOIN
dbo.School ON info.SchoolID = dbo.School.SchoolID LEFT OUTER JOIN
dbo.ShopType ON info.ShopTypeID = dbo.ShopType.TypeID LEFT OUTER JOIN
(SELECT ShopID, AVG(Money) AS avgvalue
FROM dbo.Grade
GROUP BY ShopID) AS g ON info.ShopID = g.ShopID
select aa.*,bb.test from info as aa,(select InfoID,avg(avgvalue) as test from grade group by gradeid)as bb where aa.InfoID=bb.InfoID