Hi

I have a Classrom object which holds collection of Student objects.

I want to build a query that gives me all the classrooms with specific students.
I tried this:

from Classroom c left outer join c.students as student where student.birthYear > 1981;

This is not good, because it returns a Classrom, and all of the Students, if one student's birth date is greater than 1981.
What i want is to return the Classroom, and the filtered collection of Students.

Any idea?

I would try to use a inner join instead to a 'left outer' join.