Hi,

sorry for this really stupid question.
but after searching in the forum I could find anything I could use for my problem.

I have a parent-child relationship where there is many child or none

I would to get parent objects
where EITHER the parent.FLAG = 1
OR the any of the parents.child.FLAG = 1

I know in sql I would need an ALTER JOIN.
I just could figure out how I can do the same in HQL.

Thanks for any help.

select child.parent
from Child as child
where child.flag=1
or child.parent.flag=1

but give your mapping files it depends on your association

this can also work i think

select parent
from Parent parent, Child child
where parent.flag=1
or (child.flag = 1 AND child in elements(parent.childs))