Trying to convert MS access query to pass thru query for Oracle DB - keep getting "FROM keyword not found where expected".
I fixed problems of my linked tables having prefixes not in Oracle actual tables.
Also fixed issues of double quotes vs single quote, and * vs. %
My query is the following and i keep getting the above error. Suggestions?
SELECT CLIENTS.SHISID
,' ' AS [--CLient Ad Hoc--]
,CLIENTS_AD_HOC.TYPE_OF_RECORD
,CLIENTS_AD_HOC.CLIENT_LAST_NAME
,CLIENTS_AD_HOC.CLIENT_FIRST_NAME
,CLIENTS_AD_HOC.CLIENT_DOB
,CLIENTS_AD_HOC.CLIENT_ZIP
,CLIENTS_AD_HOC.CLIENT_CITY_COUNTY
,CLIENTS_AD_HOC.CLIENT_ID
,CLIENTS_AD_HOC.CLIENT_GENDER
,CLIENTS_AD_HOC.CLIENT_RACE
,CLIENTS_AD_HOC.CLIENT_ETHNICITY
,CLIENTS_AD_HOC.LEGAL_STATUS
,CLIENTS_AD_HOC.MARITAL_STATUS
,CLIENTS_AD_HOC.EMPLOYMENT_STATUS
,CLIENTS_AD_HOC.PREGNANTSTATUS
,CLIENTS_AD_HOC.FEMALEWITHDEPENDENT
,CLIENTS_AD_HOC.STUDENT_HOME_SET
,CLIENTS_AD_HOC.DISCHARGE_DATE_DEMOG
,CLIENTS_AD_HOC.INTAKE_DATE_DEMOG
,' ' AS [--Client Program Data--]
,CLIENT_PROGRAM_DATA.PROGRAM
,CLIENT_PROGRAM_DATA.DISCHARGE_DATE
,CLIENT_PROGRAM_DATA.INTAKE_DATE
,CLIENT_PROGRAM_DATA.DISCHARGE_REFERRAL_TYPE
,CLIENT_PROGRAM_DATA.LEVELOFCARE
,CLIENT_PROGRAM_DATA.LOCATION_NAME
,CLIENT_PROGRAM_DATA.LEGALSTATUSADMIT
,CLIENT_PROGRAM_DATA.ANTICIPATED_DISCHARGE_DATE
,CLIENT_PROGRAM_DATA.LEAD_CLINICIAN_NAME
,CLIENT_PROGRAM_DATA.DISCHARGE_REASON
,CLIENT_PROGRAM_DATA.DISCHARGE_REASON_PROGRAM
,CLIENT_PROGRAM_DATA.PROGRAM_PRIMARY_PAYER
,'' AS [--Clients--]
,CLIENTS.CURRENT_JURISDICTION
,CLIENTS.FAMINCOME
,CLIENTS.PHYS_NAME
,' ' AS [--Client Program--]
,CLIENT_PROGRAM_DATA.PROGRAM_PRIMARY_PAYER
,' ' AS [--Client Custom Data--]
,CLIENT_CUSTOM_DATA.FIELD_NAME
,CLIENT_CUSTOM_DATA.RECODED_RESPONSE
,CLIENT_CUSTOM_DATA1.FIELD_NAME
,CLIENT_CUSTOM_DATA1.RECODED_RESPONSE
,DRUG_HISTORY_DATA.DRUG_CATEGORY
,DRUG_HISTORY_DATA.DRUG_DETAIL
,DRUG_HISTORY_DATA.DRUGORDER
FROM CLIENT_CUSTOM_DATA1
RIGHT JOIN (CLIENT_CUSTOM_DATA
RIGHT JOIN (DRUG_HISTORY_DATA
RIGHT JOIN (((CLIENTS
LEFT JOIN CLIENTS_AD_HOC ON CLIENTS.SHISID = CLIENTS_AD_HOC.SHISID)
LEFT JOIN CLIENT_PROGRAM_DATA ON CLIENTS.SHISID = CLIENT_PROGRAM_DATA.SHISID)
LEFT JOIN CLIENT_PROGRAM_DATA ON CLIENTS.SHISID = CLIENT_PROGRAM_DATA.SHISID) O NDRUG_HISTORY_DATA.SHISID = CLIENTS.SHISID) ON CLIENT_CUSTOM_DATA.SHISID = CLIENTS.SHISID) ON CLIENT_CUSTOM_DATA1.SHISID = CLIENTS.SHISID
WHERE (((CLIENT_CUSTOM_DATA.FIELD_NAME) LIKE 'CPS Involvement?')
AND ((CLIENT_CUSTOM_DATA1.FIELD_NAME) LIKE 'Reunification?')
AND ((DRUG_HISTORY_DATA.DRUGORDER)='1'))