I have the following relationship: Grandparent-Parent-Child - one to many down the hierarchy as you would expect.

I have some set of Child IDs and I want to get Grandparent objects that contain Parents with those Parents in a Set, and Parents containing Children in a Set, but only those children that I queried on - not all children from the database that are set through the mapping. I have the basic mapping all working - I just want to filter the results on the lowest level but I need to access through the Grandparent/Parent hierarchy. What would be the best HQL or criteria mechanism to do this?

Thanks in advance for any help.