File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL query hibernate" Watch "HQL query hibernate" New topic
Author

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 a.id right join Client c On a group by c.clientId

Hi,

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
Thanks
Raman
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HQL query hibernate