I'd love to know what other people say but from my experience this is not possible with elastic search by itself. A little python to loop through one index and search the other, or a logstash job that uses one index from elastic as input, then runs a query in the filter -- would be the two things I would recommend.