Hi,

I'm having trouble trying to build a query that brings all the objects "A" which have a many-to-one property (holds object "B"), where "B" is not associated to any object "C" (which has a many-to-many Set property of Objects "B").

Class A
id
many-to-one class="B"

class B
id
...

class C
id
Set table="CB"
many-to-many class="B"


In SQL I used to do something like
select A.*
from A left join CB on CB.b_id = A.b_id
where CB.b_id is null;

Does anybody have an idea?
Actually, I'm having trouble trying to join an object with a Set property ( many-to-many association) of another object.

Thank you.