JOIN two RT indexes within a query

Is there a way to use JOIN in a query with two indexes? Like this MySQL query:

SELECT rt2.*
FROM rt2
JOIN rt1 ON rt1.field1 = rt2.field2

The problem is that I have to store almost all data from index rt1 in other indexes. I want to have something like JOIN on RT indexes to avoid such data duplication.

You can not use join. You could create distributed index with all your indexes however you can not reference or filter our by result set from another indexes.

Thank you for the reply.