mysql以另一张表的数据进行排序

问题描述

gongsi(公司表)id:summary:artices（文章表）id:gongsi_id:content:公司排序（以文章总数进行降序排序）

解决方案

select G.id,G.summary,count(A.id) as c from gongsi as G join artices as A on A.gongsi_id = G.id order by c 你试试
解决方案二：
select id, summary from ( select G.id, G.summary, count(A.id) cnt from gongsi as G inner join artices as A on A.gongsi_id = G.id group by G.id ) t order by cnt desc
解决方案三：
select id, summaryfrom (select G.id, G.summary, count(A.id) cntfrom gongsi as G join artices as A on A.gongsi_id = G.idgroup by G.id) torder by cnt