I have a query---
select t1.column1 from table1 t1 where t1.column2=(select t2.column1 from table2 t2 where ....2 conditions) and t1.column3=(select t3.col1 from table3 t3,table t2 where ..condition)

I am not sure best way to implement using hibernate 3.0....

THe query is

select edc.da_level from CR_excessdacalculation edc where edc.excessdacal_id=
(select dacalc_id from cr_dacalcmatrix WHERE curr_type=
(select exm.currency from cr_excess_master exm WHERE exm.cif ='100090631';) and new_rg=
(select em.risk_group_id from cr_entitymaster em, cr_excess_master exm where em.cif_number ='100090631' and em.cif_number= exm.cif;);
)