Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 The Software Craftsman this week in the Agile 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
Have you tried LearnNowOnline?
subject: HQL query hibernate