Hi all,

I am stuck with a sql suery which is

select * from or_offering_values x
where cod_offering_id in ( select v.cod_offering_id from or_offering_values v
where cod_feature_id='A1' and txt_value='Y')
and cod_feature_id='F1' and txt_value='Monthly'

can any one tell how to use the query using DetachedCriteria in hibernate



Thanks in advance