title: NHibernate Multiple Criteria Difficulties
body: <p>I'm having difficulties with multiple joins in the NHibernate Criteria search.  Say I had a pet table, and I wanted to return all pets where the pet category was Dog, and the owner gender was female, ordered by the pet birthday.  I've tried a bunch of permutations for how I can get this but haven't been able to figure it out.  My latest iteration is as follows:</p>
  
  <pre><code>var recentPets = session.CreateCriteria(typeof(Pet))
              .AddOrder(Order.Desc("PetBirthday"))
              .CreateCriteria("PetType", "pt", JoinType.InnerJoin)
              .CreateCriteria("PetOwnerId", "po", JoinType.InnerJoin)
              .Add(Expression.Eq("pt.PetTypeName", petType))
              .Add(Expression.Eq("po.PersonGender", gender))
              .List&lt;Pet&gt;();
  </code></pre>
  
  <p>Thanks so much for the help!</p>