SQL IN (SELECT)

General Discussions - English
1

Hi,

Is there a similar concept of IN (SELECT) in manticore query?

Here is an example of what I am trying to do:

SELECT * FROM Products where SupplierID IN (SELECT SupplierID FROM Suppliers WHERE match('@Country USA'));

2

no
we have Searching > Sub-selects | Manticore Search Manual but they work only for reranking

3

@tomat , is there any way I can achieve the same in manticore?

4