How do you fetch table data from join table?

[flzhang132]

There are two tables: "Table A" is a detailed information, and the "Table B" is the primary key.

The two tables are associated with the primary key and only queries the information in the matching A table.

Be similar to sql
seledt T1.id from T1,T2 where T1.id=T2.id

[renjith_nair]

@flzhang132 ,

Assuming you have different indexes or source types where you have this data,

"your search to get first dataset" OR "your search to get the second dataset" 
|stats values(project_name) as project_name,values(region) as region,values(fee) as fee,values(dmon) as domon by resourceid

Another option is to use join, which should be avoided if possible due to performance considerations

"your search to get first dataset"
|join resourceid ["your search to get the second dataset"]

[flzhang132]

please ? How can i get data from same table with self join
Be similar to sql
select T2.id
from table T1
,table T2
where T1.id = T2.id

[renjith_nair]

@flzhang132 , do you mean to say, you have these events in the same source? just for clarification, why do you need this join when you dont have any interesting field in the other dataset but all the fields are in say table A ? Do you have some sample events (mask any confidential data) to let us know what you have and what's your expected output

[asabatini85]

In that case it's better use the transaction comand for the self join.