title: Use DetachedCriteria on subquery returning all fields
body: <p>i have the following query that i need to convert to Criteria</p>
  
  <pre><code>SELECT t1.id, t1.name, t2.desc, t3.date from
  (SELECT * FROM a, b, c where a.id = b.id and b.id = c.id) t1
  left join t2 on t1.id = t2.id
  left join t3 on t1.id = t3.id  
  </code></pre>
  
  <p>I read that i can use DetachedCriteria but the examples I saw so far when it only returns, say, id, for example:</p>
  
  <pre><code>SELECT * from t1 where t1.id in (select subquery.id from subquery);
  </code></pre>