I have the following Domain classes:

Instructor
Class
School

Instructors have a collection of Classes and a class is associated to a school.

I need to be able to query for all instructors in a school. I've tried the following and it's not working:

'Select i from Instructor i, Course c where c.school = :school and c in elements(i.courses)'

I've tried other variations without any luck. Any suggestions?

-Mike

BTW, I'm doing this in grails 1.1.1. I assume it shouldn't matter though.