Join table on Splunk connect DB

[indeed_2000]

Hi want to Join table on Splunk connect DB
1- table1
2- table2
3- common column (id)

I try to join them with (id) column but it give me below error

here is my query:
SELECT id
FROM table1, table2
JOIN table1.id ON table2.id;

here is the error:
java.sql.SQLException: The specified table (table1.id) is not in the database.

Any recommendation?

[jkat54]

You need to know SQL and the table you're working with to correctly do this. I recommend that you work with your SQL team or DB administrator.

[indeed_2000]

DB administrator give me SQL queries that work in their environment but not work in splunk connect DB.

[jkat54]

The error is telling you the tables don't exist.

[indeed_2000]

I know because table name is “table1” but when I join them with Sql command it will be table1.id

[jkat54]

No, the error is saying table1 does not exist in the database.

[indeed_2000]

I can see table in the list of left panel