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
1 Like
5

Can you please show me how to accomplish this using multiple select queries?

6 
SELECT Products.* 
FROM Products
INNER JOIN  Suppliers ON Suppliers.SupplierID = Products.SupplierID
WHERE match('@Country USA')