Hi all,
I have a table Allotment where i have two fields noOfAttempt and one foregn Key User_Id(User table is having UserName and Date Of Birth). Now i have to sort the records in the Allotment table based on the noOfAttempt and age. But Date Of Birth is there in the User Table.

How can i solve this problem.
Can i write a query like this.

FROM com.Allotment allotInfo order by allotInfo.noOfAttempt desc,allotInfo.User.userDob.

if it is wrong please help me out its an urgent requirement for me.

Is there any other way of sorting the records in this table please help me out its an urgent requirement for me

Regards
Sreenivasula Reddy A

Try this:



I beleive this will also work:



Note: This is the same query as your posting but the "desc" should appear at the end of all the columns in your order by.