Hi All.
Please help me to right sub query in Hibernate
i have 2 table
1.quotes
2.programs
my requirement is that when i apply filter apply on quotes table
e.g
select quote_id,Quote_name,Quote_dir from quote q where q.quote_name like 'j%';
i get all quote_id from above query
i need to pass above quote_id to another table (programs)
i need following query in Criteria format
select q.quote_id,q.Quote_name,q.Quote_dir ,p.program_name from quote q,program p where q.quote_name like 'j%'
and p.quote_id in(select quote_id from quote where quote_name like 'j%');
please help me its very very urgent
i hope you all geeks help me
Thanks