Hibernate relations

[venkatakrishna nukala]

Hi,

I want query child object while loading,

here is the query i am using :

"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 = ?   ";

but applicantperson is having 24 records, and child gpalist has 2 records with one verified = 1 and the second is having verified =0

Note: there is one to many relation between ApplicantPerson and Gpa


But the output of the above query is 30 records and gpalist is getting 2 records.

I need out put with 24 records in parent and child gpalist with one record verified =1