hi,

i am trying to make an HQL Query which use an in-clause.

The Database is defined as follows:
There is a many-to-many relation from the ChangeAlert to Change.
A datamember ("changes") is defined (in the java source) from ChangeAlert to Change only ! no other direction (from Change to ChangeAlert)

The query i try to write is something like the following:
select c from Change c, ChangeAlert a where c in a.changes

explanation on the query:
return all the Changes which have alerts "pointing" to the them (the in statement).

but it doesnt work...

the HQL Editor give the following sql statement:


select
change0_.ID as ID64_,
.....
from
CCM_CHANGES change0_,
CCM_ALERT changealer1_,
CCM_ALERTSCHGS changes2_,
CCM_CHANGES change3_
where
changealer1_.ALERT in (
'CHANGE_ALERT', .... )
and changealer1_.ID=changes2_.ALERT_ID
and changes2_.CHANGE_ID=change3_.ID
and (
change0_.ID in (
.
)
)


does anybody know how to solve this problem ??
Thanks !

How about this:






Farzad-

..