Hi Guys,

Sorry if this is a really obvious question. I've been through the docs and have the Java Persistence with Hibernate book, but can't seem to find a simple way of doing what I need.

Basically I have a class AccomType, which has a collection of Room objects. I want to retrieve all my AccomType's and their associated Room objects, but only where Room has a certain status attribute set. But I want to retrieve ALL AccomTypes (even those with no applicable Room objects)

From what I've read, I need to create a query something like

from AccomType a left join a.Rooms r with r.status=0

but the results are an Array with with first element of AccomType, and the 2nd the Rooms. While this is correct, and I could write a bit of code to assemble them into an AccomType object, is there no way of doing it so that it I can get it all back in one go?

Thanks,
Al

How about:




Farzad-