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
Get Updates on the Splunk Community!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...