I am not able to find sample hql for doing join involving two tables.

table item has a (int) userid, which refers to user table. there is a name attribute in the user table.

I want to do a sorted collection query, in the ascending order of user.name.

the equivalent sql would be
SELECT * FROM item INNER JOIN user ON item.userid=user.userid ORDER BY user.`name`

please help me with the corresponding hql.

I am assuming your class structure is something like

class Item {

..
..
User user;
..
..
}


Class User {

..
..
String name;
..
..
}


Required HQL would be

select i from item i join i.user u order by u.name

No, wrong class structure. correct one is

class Item {

int userId;
..
..
User user;

String name;
..
}

therefore, I can not do i.user, there is only i.userId, and I don't know how to do a join for that.

try this

select i from Item i, User u where i.userId = u.id order by u.name