Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Any suggestions on what is wrong with my code?
Perhaps it's not possible to use Left Joins?
I keep getting the error "FROM keyword not found where expected" when my Advanced Editor uses the following code:
let
Source = Oracle.Database("my server name", [HierarchicalNavigation=true, Query="
SELECT ND_EMARS.M_CLM_TB.PD_DT AS Date_Paid, ND_EMARS.M_CLM_TB.TCN_ID AS TCN, ND_EMARS.M_CLM_TB.STATE_COS_CD AS COS, ND_EMARS.M_CLM_TB.FUND_SRC_CD AS FUND_CODE, ND_EMARS.M_CLM_TB.FDOS_DT,
ND_EMARS.M_CLM_TB.LDOS_DT, Sum(ND_EMARS.M_CLM_TB.CMS_RPT_PD_AMT) AS PAID_AMT, Sum(ND_EMARS.M_CLM_TB.CMS_RPT_FED_PD_AMT) AS FEDERAL_AMT,
Sum(ND_EMARS.M_CLM_TB.CMS_RPT_OTHER_PD_AMT) AS DPI_STATE_AMT], ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID, ND_EMARS_M_PROV_TB.PROV_ID, ND_EMARS_M_PROV_TB.PROV_NAM_SORT,
ND_EMARS.M_CLM_TB.FIN_RSN_CD, ND_EMARS.M_CLM_TB.FIN_RSN_C, ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID, ND_EMARS.M_CLM_TB.MBR_SYS_ID
FROM (ND_EMARS.M_CLM_TB LEFT JOIN ND_EMARS_M_PROV_TB ON ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID = ND_EMARS_M_PROV_TB.PROV_SYS_ID) LEFT JOIN
(SELECT ND_EMARS.M_MBR_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID
FROM ND_EMARS_M_MBR_TB
GROUP BY ND_EMARS.M_MBR_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID)
ON ND_EMARS.M_CLM_TB.MBR_SYS_ID = ND_EMARS.M_MBR_TB.MBR_SYS_ID
WHERE ND_EMARS.M_CLM_TB.SUM_CLM_IND = 'Y' AND ND_EMARS.M_CLM_TB.CLM_INC_IND = 'Y' AND
ND_EMARS.M_CLM_TB.FIN_RSN_CD <> '248' AND ND_EMARS.M_CLM_TB.FIN_RSN_CD <> '249'
GROUP BY ND_EMARS.M_CLM_TB.PD_DT, ND_EMARS.M_CLM_TB.TCN_ID, ND_EMARS.M_CLM_TB.STATE_COS_CD, ND_EMARS.M_CLM_TB.FUND_SRC_CD, ND_EMARS.M_CLM_TB.FDOS_DT, ND_EMARS.M_CLM_TB.LDOS_DT,
ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID, ND_EMARS_M_PROV_TB.PROV_ID, ND_EMARS_M_PROV_TB.PROV_NAM_SORT, ND_EMARS.M_CLM_TB.PRCS_PER_YM,
ND_EMARS.M_CLM_TB.FIN_RSN_C, ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID, ND_EMARS.M_CLM_TB.MBR_SYS_ID
HAVING (ND_EMARS.M_CLM_TB.FUND_SRC_CD = '00700' Or ND_EMARS.M_CLM_TB.FUND_SRC_CD = '00710') AND Sum(ND_EMARS.M_CLM_TB.CMS_RPT_PD_AMT) <> 0 AND
ND_EMARS.M_CLM_TB.PRCS_PER_YM= '2022112'
"])
in
#"Source"
Solved! Go to Solution.
Hi @ND_Pard ,
'FROM keyword not found where expected' occurs when you try to execute a SELECT or REVOKE statement without a FROM keyword in its correct form and place. If you are seeing this error, the keyword FROM is spelled incorrectly, misplaced, or altogether missing. In Oracle, the keyword FROM must follow the last selected item in a SELECT statement or in the case of a REVOKE statement, the privileges. If the FROM keyword is missing or otherwise incorrect, you will see ORA-00923 FROM keyword not found where expected.
For the solution, please check the link:
ORA-00923: FROM keyword not found where expected | TekStream
Similar posts:
sql - Error (ORA-00923: FROM keyword not found where expected) - Stack Overflow
oracle - ORA-00923: FROM keyword not found where expected - SQLDeveloper - Stack Overflow
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ND_Pard ,
'FROM keyword not found where expected' occurs when you try to execute a SELECT or REVOKE statement without a FROM keyword in its correct form and place. If you are seeing this error, the keyword FROM is spelled incorrectly, misplaced, or altogether missing. In Oracle, the keyword FROM must follow the last selected item in a SELECT statement or in the case of a REVOKE statement, the privileges. If the FROM keyword is missing or otherwise incorrect, you will see ORA-00923 FROM keyword not found where expected.
For the solution, please check the link:
ORA-00923: FROM keyword not found where expected | TekStream
Similar posts:
sql - Error (ORA-00923: FROM keyword not found where expected) - Stack Overflow
oracle - ORA-00923: FROM keyword not found where expected - SQLDeveloper - Stack Overflow
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did find a few errors in my code and re-wrote it as shown below; unfortunately, now I am getting the error:
"DataSource.Error: Oracle: ORA-00904: "ND_EMARS"."M_MBR_TB"."MBR_SYS_ID": invalid identifier" but still don't understand the error ....
let
Source = Oracle.Database("nd_emars_prm_svc.mmis.nd.gov", [HierarchicalNavigation=true, Query="
SELECT ND_EMARS.M_CLM_TB.PRCS_PER_YM, ND_EMARS.M_CLM_TB.PD_DT AS Date_Paid, ND_EMARS.M_CLM_TB.TCN_ID AS TCN,
#(lf)ND_EMARS.M_CLM_TB.STATE_COS_CD AS COS, ND_EMARS.M_CLM_TB.FUND_SRC_CD AS FUND_CODE,
#(lf)ND_EMARS.M_CLM_TB.FDOS_DT, ND_EMARS.M_CLM_TB.LDOS_DT,
#(lf)Sum(ND_EMARS.M_CLM_TB.CMS_RPT_PD_AMT) AS PAID_AMT,
#(lf)Sum(ND_EMARS.M_CLM_TB.CMS_RPT_FED_PD_AMT) AS FEDERAL_AMT,
#(lf)Sum(ND_EMARS.M_CLM_TB.CMS_RPT_OTHER_PD_AMT) AS DPI_STATE_AMT, ND_EMARS.M_MBR_TB.MBR_NAM_FIRST,
#(lf)ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID, ND_EMARS.M_PROV_TB.PROV_ID,
#(lf)ND_EMARS.M_PROV_TB.PROV_NAM_SORT, ND_EMARS.M_CLM_TB.FIN_RSN_CD, ND_EMARS.M_CLM_TB.FIN_RSN_C,
#(lf)ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID, ND_EMARS.M_CLM_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_SYS_ID
#(lf)FROM (ND_EMARS.M_CLM_TB
#(lf)LEFT JOIN ND_EMARS.M_PROV_TB ON ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID = ND_EMARS.M_PROV_TB.PROV_SYS_ID)
#(lf)LEFT JOIN
#(lf)(SELECT ND_EMARS.M_MBR_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID
#(lf)FROM ND_EMARS.M_MBR_TB
#(lf)GROUP BY ND_EMARS.M_MBR_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID)
#(lf)ON ND_EMARS.M_CLM_TB.MBR_SYS_ID = ND_EMARS.M_MBR_TB.MBR_SYS_ID
#(lf)WHERE ND_EMARS.M_CLM_TB.SUM_CLM_IND = 'Y' AND ND_EMARS.M_CLM_TB.CLM_INC_IND = 'Y' AND
#(lf)ND_EMARS.M_CLM_TB.FIN_RSN_CD <> '248' AND ND_EMARS.M_CLM_TB.FIN_RSN_CD <> '249'
#(lf)GROUP BY ND_EMARS.M_CLM_TB.PRCS_PER_YM, ND_EMARS.M_CLM_TB.PD_DT, ND_EMARS.M_CLM_TB.TCN_ID, ND_EMARS.M_CLM_TB.STATE_COS_CD,
#(lf)ND_EMARS.M_CLM_TB.FUND_SRC_CD, ND_EMARS.M_CLM_TB.FDOS_DT, ND_EMARS.M_CLM_TB.LDOS_DT,
#(lf)ND_EMARS.M_MBR_TB.MBR_NAM_FIRST, ND_EMARS.M_MBR_TB.MBR_NAM_LAST, ND_EMARS.M_MBR_TB.MBR_ALT_ID,
#(lf)ND_EMARS.M_PROV_TB.PROV_ID, ND_EMARS.M_PROV_TB.PROV_NAM_SORT, ND_EMARS.M_CLM_TB.PRCS_PER_YM,
#(lf)ND_EMARS.M_CLM_TB.FIN_RSN_C, ND_EMARS.M_CLM_TB.PROV_BLNG_SYS_ID, ND_EMARS.M_CLM_TB.MBR_SYS_ID, ND_EMARS.M_MBR_TB.MBR_SYS_ID
#(lf)HAVING (ND_EMARS.M_CLM_TB.FUND_SRC_CD = '00700' Or ND_EMARS.M_CLM_TB.FUND_SRC_CD = '00710') AND
#(lf)Sum(ND_EMARS.M_CLM_TB.CMS_RPT_PD_AMT) <> 0 AND ND_EMARS.M_CLM_TB.PRCS_PER_YM = '202212'
"])
in
#"Source"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.