aspose file tools*
The moose likes Object Relational Mapping and the fly likes HQL Self Left Outer Join Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL Self Left Outer Join" Watch "HQL Self Left Outer Join" New topic
Author

HQL Self Left Outer Join

Prem Kash
Greenhorn

Joined: Dec 04, 2007
Posts: 5
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


Hope to get response soon,<br />Thanks,<br />Prem.
Devaka Cooray
ExamLab Creator
Saloon Keeper

Joined: Jul 29, 2008
Posts: 3220
    
  49

Please UseCodeTags


Author of ExamLab ExamLab - a free SCJP / OCPJP exam simulator
What would SCJP exam questions look like? -- Home -- Twitter -- How to Ask a Question
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HQL Self Left Outer Join