title: HQL-Select from 2 tables
body: <p>I am a beginner in <code>Hibernate</code>. I want to select data from two tables using <code>hql</code>.
  the problem is that the query gives me result if I select one object like this example:</p>
  
  <pre><code>(select d from eresa  e, dresa  d where  e.f_ideResa = d.eresa.f_ideResa and e.F_DATEFROM=:x)
  </code></pre>
  
  <p>but when i want to select multiples data from 2 two tables like this :</p>
  
  <pre><code>(select e.f_ideResa, d.F_PAXNAME from eresa as e, dresa as d where  e.f_ideResa = d.eresa.f_ideResa and e.F_DATEFROM=:x  ");)
  </code></pre>
  
  <p>it gives me error: </p>
  
  <blockquote>
    <p>Etat HTTP 500 - java.lang.NumberFormatException..</p>
  </blockquote>