A question about HQL cascade select

[Lei Guoguo]

hi, everyone, i have a question for HQL

we have two classes A and B, there have one-to-many relation, A is one, B is many.
and B had a field x.

question is: selected all the A's instance, required is B.x is equals 1.

please give the HQL

my answer is :
FROM A a WHERE a.b.id in (SELECT b.id FROM B b WHERE b.x = 1)

advance thanks everyone

[Rahul Babbar]

Lei Guoguo wrote:
FROM A a WHERE a.b.id in (SELECT b.id FROM B b WHERE b.x = 1)

I think the following query should work fine.

FROM A a Inner Join a.b b where b.x = 1

Since your hbm file already has the association between the entities, you dont need to explicitly match A's id with B's id.
Remember that the use of Inner Select should be avoided and it should be used by Inner Join instead(as an Inner Join is faster)

[Lei Guoguo]

Rahul, thank you very muck. i believe i was understood what you said