Here's the problem.

Two tables:
Patient
Consultation

Patient has a set with one-to-many relationship to Consultation.

One Consultation might have one or more Patient assigned.

I want to retrieve all the patients which have the same type of consultation (for example).

I was trying to do that just setting the type via consultation set attribute, but hibernate insists to retrieve all the consultations for the patient.

Anybody ever had this problem?