There are some examples on the web for this: http://yonik.com/solr/query-syntax/ http://stackoverflow.com/questions/634765/using-or-and-not-in-solr-query If you are using .NET, maybe also try SolrNet.
Maybe those help. -----Original Message----- From: Hardika Catur S [mailto:hardika.sa...@solusi247.com.INVALID] Sent: Wednesday, July 27, 2016 10:24 AM To: solr-user@lucene.apache.org Subject: Query Solr Hi, I will create a query multiple collections in solr where query in mysql like this "SELECT colection1.field_colection1 FROM colection1 WHERE colection1.field_colection1 NOT IN (SELECT colection2.field_colection2 FROM colection2);". But I find it difficult for create that query. Please help me to find a solution on. Thanks, Hardika CS.
