Match two fields based on same value

Does elasticsearch support below kind of query?

Select * from table_name1 where table_name1.id = table_name2.id.

In elasticsearch scenario, Can we match two separate fields which are
having same values?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/98e08610-3533-4bfd-9bcd-ecb5d304083b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.