Using the Criteria API, I want to create a query that generates SQL like: SELECT BranchID
FROM FIServiceLocation ORDER BY (SELECT InstitutionName FROM Institution WHERE Institution.InstitutionID=FIServiceLocation.InstitutionID) This is just an example to reflect my requirements, but hopefully it gets my point across. Effectively I want to order my results by the results of a subquery. If anyone has any advice on how to go about this (already tried banging my head against the wall...does not seem to be working), it would be much appreciated. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
