Hi All,

Please help me implement the following query in hibernate.

select count(col1),col2,col3 from tbl1
....................
..................
where ...........
.............and
col3 in (select distinct col4 from tbl2 where col_0 = ? and col_1 =?)
group by col2

this above query is to be implemented using subselect : eg:
<subselect>
select count(col1),col2,col3 from tbl1
....................
..................
where ...........
.............and
col3 in (select distinct col4 from tbl2 where col_0 = ? and col_1 =?)
group by col2
</subselect>


I have to pass parameters to col_0 and col_1 for the nested query.

any help is appretiated.

Thanks
Nandini

You should be able use SQL native queries and not worry about HQL.

HTH,
Sivec