How to do complex search in sphinx?

Question

SQL

I have 2 tables:
1) street table
2) house table
How do I make shpinx look in the street tables first and if the result is two or one street, start looking in the house tables?

Answer 1

Found the answer. It is necessary to do in SQL to add a condition.