HQL on the second side of a many-to-many mapping

anehoray · **Joined:** Tue Mar 07, 2006 4:54 am **Posts:** 6

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

zzyborg · **Posted:** Mon Aug 21, 2006 2:45 am

hi assaf,
i wonder why u want to have a many to many relationship between a car and its parts . i would rather suggest a one-to-many relationship to car-parts .

then u can query like select p.car from parts p where p.partname='something'

correct me if im wrong

pepelnm · **Posted:** Mon Aug 21, 2006 3:02 am

Code:

From Car as car inner join car.CarPart part where part='Door'

Please, don't forget to rate.

anehoray · **Joined:** Tue Mar 07, 2006 4:54 am **Posts:** 6

accidentally clicked the no (instead of yes). can you post again and i will re-rate?

10x!

pepelnm · **Posted:** Mon Aug 21, 2006 4:51 am

Rate me ;-)

anehoray · **Joined:** Tue Mar 07, 2006 4:54 am **Posts:** 6

zzyborg wrote:

hi assaf,
i wonder why u want to have a many to many relationship between a car and its parts . i would rather suggest a one-to-many relationship to car-parts .

then u can query like select p.car from parts p where p.partname='something'

correct me if im wrong

I might want to know which cars use a certain part (door)

Assaf