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?
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.
DB administrator give me SQL queries that work in their environment but not work in splunk connect DB.
The error is telling you the tables don't exist.
I know because table name is “table1” but when I join them with Sql command it will be table1.id
No, the error is saying table1 does not exist in the database.
I can see table in the list of left panel