I believe that I'm giving enough to answer the question, but if not, I'll bring in my real example with mapping files and code.

Let's say I have the following classes:



Foo and Bar are mapped as joined subclasses of FooBar.

The fooBars collection in Bat contains a number of objects, some Foo objects and some Bar objects.

What kind of HQL magic would I invoke to get all the elements of the fooBars collection that are instances of Foo?

You could try something like this:

select foos from Bat bat join bat.fooBars foos where foos.class = Foo

Don't know if this works, if somehow it might work using the .class special property, so that would be the direction to look.