title: NHibernate: Where clause on one-to-many relationships doesn't work when column name is ambiguous
body: <p>It is possible to specify an arbitrary SQL where clause for collection mappings. For example:</p>
  
  <pre><code>&lt;map name="myEntity" where="foo = 1" /&gt;
  </code></pre>
  
  <p>However if the column name is ambiguous for some reason, the sql fails. For example, this can occur if you are trying to use joins for example. </p>
  
  <p>Given that the table aliases are automatically generated, you can't qualify the column name. This makes the feature seem rather silly. Does anyone know if there is a work around?</p>