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 WHERE MATCH('@rt1.field3 SOMETEXT')
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.