• Post Reply Bookmark Topic Watch Topic
  • New Topic

HQL query hibernate

RamandeepS Singh
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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


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
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!