title: NHibernate (+ FluentNhibernate) : Join two detached tables
body: <p>'tI encounter problems to create a join on two entities with a common property but they are not map together.</p>
  
  <p>Say you have an entity Article which contains a property FamilyCode and an entity Family with properties Code and Label.</p>
  
  <p>In my mappings, Article doesn't reference Family and i don't want to change that (to keep compatibility with others internal and legacy methods).</p>
  
  <p>So, i can't translate the below query in Nhibernate :</p>
  
  <pre><code>SELECT f.Code, f.Label
  FROM Article a
  INNER JOIN Family f ON a.FamilyCode = f.Code
  WHERE f.Label LIKE 'p%'
  </code></pre>
  
  <p>I can't use JoinQuery because i can't inject a QueryOver and i don't konw if it's possible by using WithSubquery.</p>
  
  <p>I tried to Future QueryOver and QueryOver and then perform a Join in memory (after .List() each) but i have too much rows for Article so it takes long time.</p>
  
  <p>Do you have ideas ?</p>
  
  <p>Thanks.</p>