title: Usage of UNION and MINUS in SOLR
body: <p>I am working in solr where i want to use the combinations of UNION and MINUS in SOLR. I have formulated oracle query.</p>
  
  <pre><code>select * from TESTTABLE where (FT = 'PE' and emis between 10 and 20) or (FT = 'DI' and emis between 10 and 15) 
  union (
  select * from TESTTABLE where (FT &lt;&gt; 'PE' or emis not between 10 and 20) and (FT &lt;&gt; 'DI' or emis not between 10 and 15) 
  minus
  select * from TESTTABLE where (FT = 'PE' and emis not between 10 and 20) or (FT = 'DI' and emis not between 10 and 15) 
  );
  </code></pre>
  
  <p>I want to formulate an equivalent SOLR. Please assis me on to convert the oracle query to SOLR.</p>