查询时发生了错误......
select a.secucode,f.FundGrowthRates001,a.fundmain001,a.FundMain003,b.FundCategoryMaste001,d.FundQuoteNew001,e.FundAbility010_Star from FundSiteDB.dbo.JXN_FundMain a,FundSiteDB.dbo.JXN_FundCategoryMaste b,FundSiteDB.dbo.JXN_Season_FundAnalIndex c,FundSiteDB.dbo.JXN_FundQuoteNew d,FundSiteDB.dbo.JXN_FundAbility_Star e,FundSiteDB.dbo.JXN_FundGrowthRates f where a.CategoryID=b.CategoryID and a.secucode=c.secucode and a.secucode=d.secucode and a.secucode=e.secucode and c.EndDate=e.EndDate and e.enddate='' and e.CycType=36 and a.secucode=f.secucode and f.Enddate='' order by e.FundAbility010_Star desc,f.FundGrowthRates001 desc
