select t.QNA_ID, t.QNA_CLA_ID, t.INQR_CN, t.ANS_CN, t.ANS_CN_CBT, t.ANS_TYP_CD, t.INQ_CNT, t.RVSN_STT_CD, t.USE_YN, t.DEL_YN, t.FRST_REG_DT, t.FRST_RGTR, t.LAST_MDFCN_DT, t.LAST_MDFR, t.LAST_SYNC_DT, t.QNA_LV, tc.QNA_CLA_ID, tc.QNA_CLA_LRG_ID, tc.QNA_CLA_MID_ID, tc.QNA_CLA_SML_ID, tc.QNA_CLA_LEV, tc.QNA_CLA_NM from T_QNA t left join T_QNA_CLA tc on tc.qna_cla_id = t.QNA_CLA_ID;
이구문을 카운트 하고싶어서
select count(*), t.QNA_ID, t.QNA_CLA_ID, t.INQR_CN, t.ANS_CN, t.ANS_CN_CBT, t.ANS_TYP_CD, t.INQ_CNT, t.RVSN_STT_CD, t.USE_YN, t.DEL_YN, t.FRST_REG_DT, t.FRST_RGTR, t.LAST_MDFCN_DT, t.LAST_MDFR, t.LAST_SYNC_DT, t.QNA_LV, tc.QNA_CLA_ID, tc.QNA_CLA_LRG_ID, tc.QNA_CLA_MID_ID, tc.QNA_CLA_SML_ID, tc.QNA_CLA_LEV, tc.QNA_CLA_NM from T_QNA t left join T_QNA_CLA tc on tc.qna_cla_id = t.QNA_CLA_ID;
이렇게 작성을 하니 SQL Error [1140] [42000]: (conn=1229) In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'scpdb.t.QNA_ID'; this is incompatible with sql_mode=only_full_group_by 라는 에러가 계속 뜨네요 찾아보니까 my.inf? 들어가서 설정을 바꿔야한다는데 다른방법은 없을까요?