如下所示为我的SQL查询报错
complete! use time:151 end time Tue Jun 23 14:29:39 CST 2020null
Caused exception message is: ORA-00979: 不是 GROUP BY 表达式
SQL查询语句如下所示
SELECT
"T_FIN_LoanEntry".FAmount AS "FAmount",
"T_FIN_Loan".FTypeID AS "FTypeID",
"T_FIN_FinancingProducts".FID AS "FID",
"T_FIN_FinancingProducts".FName_l2 AS "FName",
"T_FIN_Loan".FCompanyID AS "FCompanyID"
FROM
T_FIN_FinancingProducts AS "T_FIN_FinancingProducts" INNER JOIN (T_FIN_LoanEntry AS "T_FIN_LoanEntry" INNER JOIN T_FIN_Loan AS "T_FIN_Loan" ON ("T_FIN_LoanEntry".FParentId="T_FIN_Loan".FID))
ON ("T_FIN_FinancingProducts".FID="T_FIN_Loan".FTypeID)
where "T_FIN_FinancingProducts".FID in ('umYAAABTeAbCXtep','umYAAAABNRrCXtep')
GROUP BY "T_FIN_Loan".FCompanyID
将其更改为如下SQL语句则可解决报错
SELECT
"T_FIN_LoanEntry".FAmount AS "FAmount",
"T_FIN_Loan".FTypeID AS "FTypeID",
"T_FIN_FinancingProducts".FID AS "FID",
"T_FIN_FinancingProducts".FName_l2 AS "FName",
"T_FIN_Loan".FCompanyID AS "FCompanyID"
FROM
T_FIN_FinancingProducts AS "T_FIN_FinancingProducts" INNER JOIN (T_FIN_LoanEntry AS "T_FIN_LoanEntry" INNER JOIN T_FIN_Loan AS "T_FIN_Loan" ON ("T_FIN_LoanEntry".FParentId="T_FIN_Loan".FID))
ON ("T_FIN_FinancingProducts".FID="T_FIN_Loan".FTypeID)
where "T_FIN_FinancingProducts".FID in ('umYAAABTeAbCXtep','umYAAAABNRrCXtep')
GROUP BY "T_FIN_Loan".FCompanyID
以上就是我关于 SQL-查询报错ORA-00979 不是 GROUP BY 表达式 知识点的整理与总结的全部内容，希望对你有帮助。。。。。。。
