Hi,

Can i write an HQL query which defines subselect in it.
explaining:

lets assume i have two entites A and B and the relation is many-to-many.

A
---
int x;
int y;

"lazy"
Collection getB();


------------------------

i want to write something like:
select a
from A a
inner join subselect a.b
where a.x =0;



like i can write (if i want to get b eagerly)
select a
from A a
inner join fetch a.b
where a.x =0;



can i do something like that ??

many thanks,
Eran.

Both the queries are valid. But the difference is:

Here collection b is lazy loaded and when ever you access it another query is issued to fetch each element of b.



Here b is fetched eagerly with join.

Depending on the requirement - to use 'b' or not, you can write either of the queries.

thank u for the reply.

i checked it (the "subselect"), and it is not legal - unless the syntax is not correct.

what i wrote (with the subselect) is just an example for the query syntax
i am looking for.

i want also for the subselect query to execute on the HQL query itself,
and not later when it is needed (through lazy loading).
i am looking for something like "eager subselect" in the HQL query - meaning the data will be retrieved in another query -
so, the duplicates i am suffering from, will be remove.