Joined: Tue Jul 11, 2006 4:22 pm Posts: 9
|
Hi i have next query :
select doctor
from Doctor doctor
left join fetch doctor.contactdoctorSet c
where doctor.specialization in (:specialization)
when doctor have more than one contact, he is in return list just as many times as contacts occurences.
I thougth that join fetch only initialize collection and didn't really create join.
This is problem for me because when i want to display 10 doctors on page and two of them have two contacts i have only 7 real doctors in my result.
plz help Thanks ...
|
|