Don't think I'm heading in the right direction:

Trying to convert:
SELECT p.* FROM Projects p INNER JOIN ProjectMembers pm ON pm.pid = p.pid AND pm.username = 'xyz'

to hibernate:
List list = session.find("from Projectmembers where username = 'xyz'");
List pms = session.createCriteria(Projects.class).add(Expression.in("projectmembers", list) ).list();

Iterator it = pms.iterator();


Any pointers appreciated. Thank you

session.find("from Projects p inner join p.members as member where member.username = 'xyz'");

Thank you!