title: How to use AND OR operator in hibernate Detached criteria query
body: <p>I have a requirement to use AND/OR operator to hibernate detached criteria queries.
  I want to emulate SQL eqivalent to:</p>
  
  <pre><code>Select * from myTable where city in ( X, Y ) OR city in (A,B);  
  </code></pre>
  
  <p>// Note i need to use multiple 'In'  here</p>
  
  <p>How to create citeria query to use 'OR' operator.</p>
  
  <p>Something like</p>
  
  <pre><code>DetachedCriteria criteria = DetachedCriteria.forClass(
      myClass.class)
     .add(Property.forName("city").in(X,Y));
  criteria.**Or**(add(Property.forName("city").in(X,Y));
  </code></pre>
  
  <p>Unfortunatly there is no OR method in criteria , only add there.</p>
  
  <p>Thanks in advance</p>