Hi all , I have a table relationship as follow :

cart <--- item

I retrieve the cart by
select cart, sum(cart.price) from foo.Cart cart join cart.item item

So I would like to :
1) sort the retrieved item by sum(cart.price) and then cart.createDate
2) page it using setMaxResults(10)

How could I do it most simply ? As I tried
select cart, sum(cart.price) pricesum from foo.Cart cart join cart.item item order by pricesum, cart.CreateDate
which is invalid.

THanks for help.

Perseus