title: Fluent Nhibernate left join
body: <p>I want to map a class that result in a left outer join and not in an innner join.</p>
  
  <p>My composite user entity is made by one table ("aspnet_users") and an some optional properties in a second table (like FullName in "users").</p>
  
  <pre><code>  public class UserMap : ClassMap&lt;User&gt; {
      public UserMap() {
          Table("aspnet_Users");
          Id(x =&gt; x.Id, "UserId").GeneratedBy.Guid();
          Map(x =&gt; x.UserName, "UserName");
          Map(x =&gt; x.LoweredUserName, "LoweredUserName");
  
         Join("Users",mm=&gt;
                          {
                              mm.Map(xx =&gt; xx.FullName);
  
                          });
      }
  }
  </code></pre>
  
  <p>this mapping result in an inner join select so no result come out is second table as no data. I'd  like to generate an left join. </p>
  
  <p>Is this possible only at query level?</p>