MYSQL 怎么 LEFT JOIN 多表联查

三表联查

        SELECT 
        a.id,
        a.title,
        a.author,
        a.content,
        a.cover,
        a.category_id,
        a.browse,
        a.created_at,
        b.name AS category_name,
        b.id AS category_id,
        COUNT(c.article_id) AS comments_sum
        FROM article a 
        LEFT JOIN category b ON a.category_id = b.id
        LEFT JOIN comments c ON a.id = c.article_id
        GROUP BY a.id
        ORDER BY a.created_at DESC
        LIMIT (1-1) * 10, 10;   //  1是页码  10是每页条数  最后这一行是分页

二表联查

        SELECT
        a.id,
        a.title,
        a.author,
        a.content,
        a.cover,
        a.category_id,
        a.browse,
        a.created_at,
        b.name AS category_name,
        COUNT(c.article_id) AS comments_sum 
        FROM article a
        LEFT JOIN category b ON a.category_id = b.id
        WHERE a.id = id

最好是 LEFT JOIN … NO … 这样一行一行的写

参考文章地址
https://blog.csdn.net/wqzbxh/article/details/84400788