Hi,

I have a many-to-many mapping with the following classes/ tables:
Car
Part
CarPart (implementing the many-to-many)

I would like to make the following query to find all cars that have the car part='Door'.

How would I do that? From Car AS car WHERE car.CarPart.Part='Door' ?

Thanks,

Assaf

If you have mapped the many-to-many using the normal colleciton technique (using the many-to-many element), then ignore the CarPart table. It's hidden by hibernate. The query would be "from Car c where c.Parts.Name = 'door'", assuming that you've mapped "Parts" as the name of the collection containing a car's parts (i.e. you have a method Set<Part> getParts();).