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
 
jQuery in Action, 2nd edition
 
subject: HQL query hibernate
 
Similar Threads
how to use variable with oracle like
Correlated Subquery in Hibernate
Joins in Hibernate
SQL to HQL
SubQuery in Hibernate