I have 2 table that need to join them in splunk connect db in (sql_explorer)
1- table1 (sysindexes)
2- table2 (systables)
3- common column (tableid)
I try to write join query with (tableid) column but it give me below error
here is my query:
SELECT tabid, tabid
FROM sysindexes, systables
RIGHT JOIN sysindexes.tabid ON systables.tabid;
here is the error:
java.sql.SQLSyntaxErrorException: A syntax error has occurred.
No results found.
