mysql - 错误代码 : 1055. SELECT 列表的表达式 #2 不在 GROUP BY 中

Question

我想知道“member_seq”的计数与“R_INFO.nick_name”的值匹配。

如何获取计数数据？

SQL

SELECT
    nick_name,
    REPORT.seq_no,
    report_type,
    report_item,
    contents,
    DATE_FORMAT(report_dt, '%Y-%m-%d %H:%i:%s') AS report_dt,
    REPORT.status,
    question,
    E_INFO.status AS game_status,
    entry_fee,
    REPORT.game_seq,
    Count(member_seq)
FROM
    REPORT
LEFT JOIN R_INFO ON
    REPORT.member_seq = R_INFO.seq_no
LEFT JOIN E_INFO ON
    REPORT.game_seq = E_INFO.seq_no
GROUP BY R_INFO.nick_name;

Answer 1

我无法保证您的 JOIN 逻辑是否正确，但要修复错误，如其文本所示，您需要删除所有未聚合或分组的列。所有这些:

REPORT.seq_no,
report_type,
report_item,
contents,
DATE_FORMAT(report_dt, '%Y-%m-%d %H:%i:%s') AS report_dt,
REPORT.status,
question,
E_INFO.status AS game_status,
entry_fee,
REPORT.game_seq

查询将变为:

SELECT nick_name, Count(member_seq)
FROM REPORT
LEFT JOIN R_INFO ON REPORT.member_seq = R_INFO.seq_no
LEFT JOIN E_INFO ON REPORT.game_seq = E_INFO.seq_no
GROUP BY R_INFO.nick_name;