title: Hibernate relations
body: <p>I want to query child object while loading, </p>
  
  <p>here is the query i am using : </p>
  
  <pre><code>SELECT app FROM ApplicantPerson app left join app.gpaList gpa , DesignatedSchool ds
  WHERE
      app.applicantPersonId.applPersonId = ds.applPersonId 
      AND app.appStatusCd = 'P'  and gpa.verifiedInd= 1
      AND ds.designateStatusCd = 'A' 
      AND ds.medInstId = ?  
      AND app.applicantPersonId.applYear = ?
      AND ds.applYear = ?
  </code></pre>
  
  <p>but applicantperson is having 24 records, and child gpalist has 2 records with one verified = 1 and the second is having verified =0 </p>
  
  <p>Note: there is one to many relation between ApplicantPerson and Gpa </p>
  
  <p>But the output of the above query is 30 records and gpalist is getting 2 records. </p>
  
  <p>I need out put with 24 records in parent and child gpalist with one record verified =1 </p>