Query consilidation

[Bai Shen]

I have a table that references another table in a one to many relationship. I have the name of one of the objects in the table, and I want to find all of the other objects in the table that refer to the same object in the other table as one that I have. It's not as confusing as it sounds. I've gotten it to work with the following setup. I'm just not sure how to make them work as one query instead of two.

			String qs = "select organization.id from User u where u.name=:name";
			Query q = s.createQuery(qs);
			q.setString("name", userName);
			long orgID = (Long)q.setReadOnly(true).uniqueResult();

			qs = "select u.name from User u where u.organization.id=:orgid";
			q = s.createQuery(qs);
			q.setLong("orgid", orgID);
			List<String> lt = q.setReadOnly(true).list();

[Tomasz Szymanski]

Wouldn't this work?

select u1.name from User u1, User u2 where u1.organization.id = u2.organization.id and u2.name = :name