How to search linked tables in sphinx?

Question

Sphinx

There is a search on sphinx. Under the main table searches remarkably. But it is also necessary that the entered queries also search for related tables. I considered MVA, but as far as I understand, it only accepts IDs. Actually the question is, how can such a search be organized?

Answer 1

in sql_query, you just need to write a query for related tables using joins.

Answer 2

Make a source for each table and make a distributed index