Can we use SQL Join in elastic query?

can we apply nested query in two indexes ? If yes , what is the query syntax ?