一个文章表，一个评论表，得到一个标题跟评论数的列表

SELECT
    a.title,
    COUNT(b.id) AS 'Comment Count'
FROM
    fa_wo_page a
LEFT JOIN
    fa_wo_comment b ON a.id = b.woid
GROUP BY
    a.id

 

转载于:https://www.cnblogs.com/bushe/p/7240566.html