https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464947#M57134 <P>I’m wondering how can I write simple sql command to join two table in sql editor on splunk.</P> <P>For e.g. when I run below query give me syntax error.<BR /> SELECT * FROM "sysmaster":"sysadtinfo". "sysbufpool"</P> <P>sysmaster: database name<BR /> sysadtinfo: table1<BR /> sysbufpool: table2</P> <P>Is this right syntax?</P> Tue, 11 Feb 2020 13:19:58 GMT indeed_2000 2020-02-11T13:19:58Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464947#M57134 <P>I’m wondering how can I write simple sql command to join two table in sql editor on splunk.</P> <P>For e.g. when I run below query give me syntax error.<BR /> SELECT * FROM "sysmaster":"sysadtinfo". "sysbufpool"</P> <P>sysmaster: database name<BR /> sysadtinfo: table1<BR /> sysbufpool: table2</P> <P>Is this right syntax?</P> Tue, 11 Feb 2020 13:19:58 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464947#M57134 indeed_2000 2020-02-11T13:19:58Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464948#M57135 <P>You may want to ask this question in the forum for the database you are querying.</P> Tue, 11 Feb 2020 13:51:45 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464948#M57135 richgalloway 2020-02-11T13:51:45Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464949#M57136 <P>Would you please send link of forum?</P> Tue, 11 Feb 2020 14:05:47 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Syntax-error/m-p/464949#M57136 indeed_2000 2020-02-11T14:05:47Z