list = s.createQuery( "from Human h inner join h.friends as f with f.nickName like 'bubba'" ).list();