求助：Sql 语句问题

大概这样select article_id,count(like_id),count(commenter_id)from(select … from article a left join like b on …left join comment c on… ) d group by article_id

嗯，好像是，不然试试这样，a和b连接，结果再和c 连接
select d.article_id,d.liker_s,count(c.commenter_id) as commenter_s
from (select a.article_id,count(b.liker_id)as liker_s from article a
left join `like` b on a.article_id=b.article_id
group by a.article_id)d
left join `comment` c
on d.article_id=c.article_id
group by d.article_id,d.liker_s