如何使用SphinxQL搜索和连接多个索引？(How to search and join multi indexes with SphinxQL?)

如何使用SphinxQL搜索和连接多个索引？(How to search and join multi indexes with SphinxQL?)

我有2个索引， indexB和indexB 。 有2个索引有不同的列。

例：

指数A：

+---+-----+ |id |text | +---+-----+ |1 |john | |2 |tom | |3 |sam | +---+-----+

指数B：

+---+---------+-----+ |id |parentid |num | +---+---------+-----+ |1 |1 |64 | |2 |1 |128 | |3 |2 |256 | +---+---------+-----+

题：

我怎么得到这样的结果？

/*Client search*/ SELECT A.id, A.text, B.num FROM indexa A INNER JOIN indexb B ON A.id = B.parentid WHERE B.num > 100

结果：

+-----+--------+-------+ |A.id | A.text |B.num | +-----+--------+-------+ |1 |john |128 | |2 |tom |256 | +-----+--------+-------+

I have 2 indexes, indexA and indexB. There 2 indexes have different columns.

Example:

Index A:

+---+-----+ |id |text | +---+-----+ |1 |john | |2 |tom | |3 |sam | +---+-----+

Index B:

+---+---------+-----+ |id |parentid |num | +---+---------+-----+ |1 |1 |64 | |2 |1 |128 | |3 |2 |256 | +---+---------+-----+

Question:

How do I get result like this?

/*Client search*/ SELECT A.id, A.text, B.num FROM indexa A INNER JOIN indexb B ON A.id = B.parentid WHERE B.num > 100

Result:

+-----+--------+-------+ |A.id | A.text |B.num | +-----+--------+-------+ |1 |john |128 | |2 |tom |256 | +-----+--------+-------+

最满意答案

编辑索引查询后，问题解决了。

解决索引查询：

SELECT A.id,A.text,B.num FROM tableA A LEFT JOIN tableB B ON A.id=B.parentid

搜索查询：

SELECT * FROM indexA

After edit index query, problem solved.

Solved index query:

SELECT A.id,A.text,B.num FROM tableA A LEFT JOIN tableB B ON A.id=B.parentid

Search query:

SELECT * FROM indexA