how to map hibernate joins

surya.bhavanasi · **Joined:** Tue Aug 03, 2010 2:21 am **Posts:** 3

select count(a.idconsumer )from ConsumerMsgcatSent a join ConsumerOffer b on (a.idconsumer=b.consumerId) where a.idconsumer =:idconsumer and b.noOffer >= (select count(c.idconsumer) from ConsumerMsgcatSent c where c.idconsumer =:idconsumer.

table1: ConsumerMsgcatSent
table2: ConsumerOffer

plz tel me how to execute this query in hibernate,
wat type of coding have to write wer.

shynate26 · **Posted:** Mon Aug 09, 2010 5:42 am

Code:

Long count = (Long)session.createQuery("smp","select count(a.idconsumer )from ConsumerMsgcatSent a join ConsumerOffer b on (a.idconsumer=b.consumerId) where a.idconsumer =:idconsumer and b.noOffer >= (select count(c.idconsumer) from ConsumerMsgcatSent c where c.idconsumer =:idconsumer").setLong("idconsumer",value).uniqueResult();

Hope this helps.