title: HQL with IN clause
body: <p>Query is:</p>
  
  <pre><code>select e from Customer 
  join e.Address ad where ad.Id =:Id and :houseNo in (ad.houseNos);
  </code></pre>
  
  <p>I am setting all parameters in query properly, but I am getting syntax error exception.</p>
  
  <p>So, my question is can we pass the <code>houseNo</code> as an input parameter?
  Query will select the address of customer and his house should be one of houses of that street address.</p>
  
  <p>Data Model:-- Customer is main table that has a list of Address and in turn Address has a list of house no. I have address id and house no. So, I need to get customer details who is living in specified house no of specified address.</p>