ora-00979 不是group by 表达式
SQL 语句 如下
SELECT CFC.CUST_CODE, CFC.REF_NO, CFC.OWNER_CODE, CUST.COMP_REF_NO
FROM SCMS.CFC_MASTER_FOR_USER_ROLE CFC, SCMS.CUSTOMER CUST
WHERE CFC.STATUS = '在线'
AND CFC.OWNER_CODE = 'DATANG'
AND CUST.CUST_CODE = CFC.CUST_CODE
group by CFC.ref_no,
CFC.cust_code,
CFC.owner_code,
CFC.status,
CFC.department_code
ORDER BY CFC.CUST_CODE ASC, CFC.REF_NO ASC
报 ora-00979 不是group by 表达式(红色部分)
在group by 语句中加上CUST.COMP_REF_NO 就不报错了 为什么啊?