ICS Database adapter sql is not working and throwing Error: ORA-00933: SQL command not properly ende
Summary
ICS Database adapter sql is not working and throwing Error: ORA-00933: SQL command not properly endedContent
Hi,
I have two tables Report_History and Report_Master. I'm trying to join the two tables using the below query. It's working perfectly in sql developer, but not working in ICS Database adapter and throwing the below error.
Error: ORA-00933: SQL command not properly ended
select rm.report_name, report_absolute_path, rm.attrib1, rm.attrib2,
report_exe_time, last_success_report_exe_time
from report_master rm, report_history rh
where rm.report_name =rh.report_name
Please suggest me how to use join queries in Oracle ICS.
1