查询时发生了错误......
select a.FundMainManagerID,FundMainManager001,star,a.InvestAdvisorOutlineID,InvestAdvisorOutline001,a.FundMainManager021 from FundSiteDB.dbo.JXN_FundMainManager a inner join (select FundMainManagerID,SUM(ManagerAbility006_STAR)/COUNT(ManagerAbility006_STAR) star from FundSiteDB.dbo.JXN_ManagerAbility_STAR where EndDate=(select MAX(enddate) from FundSiteDB.dbo.JXN_ManagerAbility_STAR) and cyctype=12 group by FundMainManagerID) as b on a.FundMainManagerID=b.FundMainManagerID inner join FundSiteDB.dbo.JXN_InvestAdvisorOutline c on a.InvestAdvisorOutlineID=c.InvestAdvisorOutlineID and fundmainmanager010=1 order by star desc 
