I have an issue, I have 2 separate searches
1) Comes with Emp id and tempid
2) comes with Emp id
I need to join 2 searches based on group by tempid
You can join to searches using join or stats command but group by field should be exists on both search results. In your case you can only join group by Empid. If you can provide your searches (anonymized) we can help better.
My bad I have a common empid in both searches, how can I do it