Hi,

Say I have a Cat object which has a one to many collection Kittens such that myCat.getKittens() returns a collection of Kitten objects.

If there is a method Kitten.getName(), how might one, say, select all Cats which have Kittens of name Fred? I am envisioning something like:

"Select Cat from cats as cat where cat.kittens.contains(kitten.name='Fred')"

(I know my HSQL is bad and the query I invented is silly but hopefully it gets the point across :) )

Thanks for the info,
Gabe

My apologies...

I am wondering how to do this for a many to many Collection relationship not one to many. (Where a Cat has many kittens and a kitten may have multiple cats.)

Thanks!

"Select cat from Cat as cat join cat.kittens as kitten where kitten.name = 'Fred'" might work