All Apps and Add-ons

splunk connect DB join tables


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.

0 Karma