title: Nhibernate HQL Subselect queries
body: <p>I have the following SQL query:</p>
  
  <pre><code>select c.id
  from (select id from customers) c
  </code></pre>
  
  <p>This query has no practical value - I simplified it greatly for the purpose of this post.</p>
  
  <p>My question: is it possible have a subquery in the from clause using HQL. If not, can I perhaps query the customers first, kinda like a temp table in sql, and then use the result as the source of the next query?</p>
  
  <p>thanks</p>