查询时发生了错误......
select a.InvestAdvisorOutlineID,InvestAdvisorOutline001,star,avestar,b.InvestAdvisorOutline020 from (select InvestAdvisorOutlineID,sum(CompanyAbility011_Star) as star,sum(CompanyAbility011_Star)/COUNT(CompanyAbility011_Star) as avestar from FundSiteDB.dbo.JXN_CompanyAbility_Star where EndDate=(select MAX(enddate) from FundSiteDB.dbo.JXN_CompanyAbility_Star) and cyctype=36 group by InvestAdvisorOutlineID) as a inner join FundSiteDB.dbo.JXN_InvestAdvisorOutline b on a.InvestAdvisorOutlineID=b.InvestAdvisorOutlineID order by star desc,avestar desc
