Please provide suggestions on this

Index 1 and index 2 had common entity (Ex. Empl no.)
how to Create join query to search on index1 and get the document from index2 based on the common entity(emp no)

You cannot in ES.

Can we achieve this using a 3rd party plugin?