• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HQL Self Left Outer Join

 
Prem Kash
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to have a self Left outer join on the table using HQL(Hibernate Query language), can anybody please help...

Here are the classes




And I wanyt to implement the following query using HQL or Criteria Query, can anybody please help.

select j1.job_item_id, j2.job_item_id, j1.job_item_status,j2.job_item_status from tt_job_item as j1 left join tt_job_item as j2 on j1.locked_item = j2.locked_item

 
Devaka Cooray
ExamLab Creator
Marshal
Pie
Posts: 4690
337
Chrome Eclipse IDE Google App Engine IntelliJ IDE jQuery Postgres Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please UseCodeTags
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic