How do you select values on two tables?

[wallyd241]

Hi !
I want to select values ​​in two different tables to join via table values ​​but I have a compilation error.
Can you help me please ? (See picture):
I want to select idenvoi, idflux, and statut from "PAS_RAU"."T_ENVOI" and idenvoi from "PAS_RAU"."T_DECLARATION"

alt text

[wallyd241]

Thank you for this help:
In the Db connect hi no accepte this syntax, i add the "shortnames=false" on the search.

Thanks.

[mstjohn_splunk]

hi @wallyd241 ,

Did you get a chance to check out @vishaltaneja07011993 's answer? Did it work for you? If so, would you approve his answer so that the rest of the community knows it's correct? If it's not correct, would you update us as to the status of your problem?

Thanks!

[vishaltaneja070 · Accepted solution]

Hello @wallyd241 ,

There are two ways to do it:
1. Change the Column name directly like :
select e.IDFLUX, e.IDENVOI as IDENVOI1, d.IDENVOI as IDENVOI2, e.STATUT from PAS_RAU.T_ENVOI e, PAS_RAU.T_DECLARATION d
2. Use shortnames attribute: set shortnames=false
Syntax: shortnames=
Description: By default, the returned fields will be in the form ... Set the shortnames argument to true to
return fields called .

like | dbxquery query="your_query" connection="connection_name" shortnames=false
http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Commands