Meaningless Drivel is fun!
The moose likes Object Relational Mapping and the fly likes HQL query hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL query hibernate" Watch "HQL query hibernate" New topic

HQL query hibernate

RamandeepS Singh
Ranch Hand

Joined: Aug 25, 2009
Posts: 63
SELECT c from (SELECT Count(*) as abc , a1 as id FROM Auction a1,MaterialList ml where a1.material_list.materialListId=ml.materialListId and ml.materialListStatus.materialListStatusId=2 GROUP BY a1.client.clientId ) as Auction as right join Client c On a group by c.clientId


I m new to hibernate

I m using subquery in from clause n wanna apply right join to the result of subquery with client table

Can anybody tell me the exact syntax for this

Please Help
I agree. Here's the link:
subject: HQL query hibernate
It's not a secret anymore!