title: Hibernate cannot run this hql query
body: <p>I have this query</p>
  
  <pre><code>select faktur.* from
  (select a.no_do, a.no_faktur, b.dlr_nama, a.crea_date from honda_h100_fakdos a, honda_h000_dealers b where a.kd_dlr=b.kd_dlr and a.status&lt;&gt;'X' and a.do_tahun&gt;='2012') faktur 
  </code></pre>
  
  <p>it's running without problem on my SQL manager, but i always getting  this error message when I convert this SQL to HQL.</p>
  
  <pre><code>"expecting IDENT, found '*' near line 1"
  </code></pre>
  
  <p>below is my HQL</p>
  
  <pre><code>select f.* (select a.noDo, a.noFaktur, a.creaDate from HondaH100Fakdos a where a.status &lt;&gt; 'X' and a.doTahun &gt;= '2012' and a.doBulan = '02')  f
  </code></pre>
  
  <p>I am still a beginner in Hibernate and Java.</p>
  
  <p>Can somebody explain why Hibernate cannot translate this query to HQL?</p>