1.问题描述
查询主表数据,要显示子表的数量,但是主表有的数据显示有的不显示,不应该是不管子表有没有数据,主表的数据应该都显示出来嘛?
2.看SQL代码
SELECT
t.tuid,
t.paper_name AS paperName,
CASE t.paper_type WHEN 'Y' THEN '在线组卷' WHEN 'N' THEN '上传组卷' ELSE '未知' END AS paperType,
t.modify_date AS modifyDate,
t.creator_date AS creatorDate,
COUNT(tpq.id) AS topicNumber,
t.is_sharing AS isSharing,
t.creator_name AS creatorName,
t.download_numbers AS downloadNumbers,
t.issue_status AS issueStatus
FROM
t_test_paper t
LEFT JOIN
t_paper_question tpq ON t.tuid = tpq.paper_tuid
GROUP BY tpq.paper_tuid
ORDER BY t.modify_date DESC
执行结果
表数据查看
不知道为什么只能查出第一条。。。。求大佬解答