Convert to criteria query

Question

How can I write criteria query to this following sql query.

select i.item_id,i.item_name,l.item_price 
from items i,pricelists l,sections s 
where i.id=100 and l.item_id=100 
and i.item_id not in (select s.item_id where s.id=100);

Thanks in Advance

is you question mainly around how do you do the `not in` ? otherwise its a simple create criteria on Item and put restrictions.. — aishwarya, Dec 23 '11 at 15:15

score 1 · Answer 1 · edited May 23 '17 at 12:20

1

Here's a link to an article on some basic Hibernate Criteria examples, and here's a link to a question here on SO where the "NOT IN" was solved.

edited May 23 '17 at 12:20

Community

1
1

answered Dec 23 '11 at 15:20

Aaron

55,518
11
116
132

Convert to criteria query

1 Answers1