오라클 티베로 Expression is not in a GROUP BY clause.

Expression is not in a GROUP BY clause. 에러남.

---

에러나는 코드 :

SELECT A.SECT_ID, B.SECT_NM FROM TABLE_SECT_5MI A 
LEFT JOIN SECT_INF B 
ON A.SECT_ID = B.SECT_ID
GROUP BY A.SECT_ID ;

 

해결한 코드 :

SELECT A.SECT_ID, B.SECT_NM FROM TABLE_SECT_5MI A 
LEFT JOIN SECT_INF B 
ON A.SECT_ID = B.SECT_ID
GROUP BY A.SECT_ID, B.SECT_ID ;

이유 :

SELECT 문의 컬럼 개수와 GROUP BY 컬럼 개수가 맞지 않아서!!