title: passing list to IN clause in HQL or SQL?
body: <p>I get <code>List&lt;Strings&gt;</code> by executing a query. This must be passed to another query of <strong>IN</strong> clause values. How to pass them in <strong>HQL</strong>?</p>
  
  <p>We can convert <code>List</code> to <code>Array</code> and can pass it, that's not a problem.</p>
  
  <p>Finally, I must pass the list in <code>List&lt;String&gt;</code> or <code>Array</code> or <code>String</code> form to the <strong>IN</strong> clause.</p>