这样的子查询如何构建?
如下：
SELECT a.*,fn.fundtype FROM ( SELECT innerCode,PersonalCode,Name,Incumbent,AccessionDate,DimissionDate,ManagementTime,Performance FROM mf_fundmanager where InnerCode>0 and PersonalCode=1000 and PostName=1 ORDER BY AccessionDate DESC) as a INNER JOIN `mf_fundarchives` as fn on a.InnerCode=fn.InnerCode GROUP BY a.InnerCode limit 10
1 条评论
不是很懂你的问题。