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