I think this is a feature added in 2.0+

Tuna Toksöz
Eternal sunshine of the open source mind.

http://devlicio.us/blogs/tuna_toksoz
http://tunatoksoz.com
http://twitter.com/tehlike




On Thu, Sep 17, 2009 at 4:57 PM, paper1337 <[email protected]> wrote:

>
> 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to