Register / Login
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Object Relational Mapping
comparing two table - hibernate criteria
posted 6 years ago
i have two tables A and B, now i need to compare two tables i.e. (select id form A) - (select id from B)
i can do this with sql query like
SELECT * FROM A WHERE NOT EXISTS (SELECT * FROM B WHERE A.Id = B.Id)
but how can i achieve the same with hibernate criteria
any help would be appreciated.
Boost this thread!
Hibernate Performance for CRITERIA / SELECT Queries..
Criteria on joining fails
Criteria with IN clause that comes from a sub sql
Hibernate:Trying to emunate select * from my_table where ID in ('MOSU0002','MOSU0003') in Hibernate