Query Solr

[Hardika Catur S]

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.