title: how i can manipulate nested query j2ee hibernate
body: <p>I have the following query, the problem that hibernate does not support nested after the 'from' I tried to create a view, but it did not work, I want to know how can I use hibernate to run this query correctly</p>
  
  <pre><code>SELECT sum(dc.nbrDefaut) def, a.nb control,c.id_of
  FROM controlequalite c ,detailscontrole dc,
  (select sum(nbreControlle) nb, id_monitrice 
    from controlequalite group by id_monitrice) a
    where c.id = dc.id_controle 
  and c.id_monitrice = a.id_monitrice 
  and  c.date &gt;= '2016-03-25 00:00:00' 
  group by c.id_monitrice,c.id_of;
  </code></pre>