Hi experts

I am new to Hibernate and think it is great.

I have a query and can't find how to write it in HQL.


Part Table
==========
part_id (key)
name

Product Table
==========
product_id (key)
title

Many to Many relationship primary product to part
Product_Part table is used to track the relationship but it is not an entity.

I Want to write the following HQL query.

I want to get the list of parts that are not in product 123.

In SQL I would write it like this:

select part.part_id from part, deployment_part
where part.part_id = product_part.part_id and product_part.product_id <> 123;

thanks,

Bob

select p.id from Part p where p not in (
select dp from Part dp where dp.product.id = 123)

Thanks your reply got me on the right track, I ended up with:

from Part r where r not in
(from Part r2 where r2.products.id = :part_id)
order by r.name a

thanks again

Bob