4

How Can I translate the following SQL query to Criteria query:

Select A.TextProperty, B.TextProperty, Count(C.Id)
From A, B, C
Where A.Id In 
(
   Select A.Id, C.Id, Count(C.Id)
   From A, C
   Having Count(C.Id) > 1
)

I know the Where part is incorrect, but I need to find a way to get only the A.Id after the inner/Sub-query select statement is executed.

Is there any way to select only the A.Id property from the sub-query then apply the Where condition on it?!

Please help me figure this out!

Ruba
  • 867
  • 3
  • 11
  • 19

0 Answers0