• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

two table mapping.

 
Saravanan Subramani
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
in hibernate, is it possible to make query like this,

select transaction_id from table1 o where o.STATUS LIKE 'COM%' and o.transaction_id in (select id from table2 where country = :country)

just i want to join two table and get a result.

Thanks in advance.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hibernate questions go into the ORM forum. You already know this because you already posted before in that forum. Why the change?

Moving this to the correct forum.

Mark
 
Saravanan Subramani
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for moving to ORM.
 
Saravanan Subramani
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kindly reply if there is any solution...

Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic