title: SQL query with inner join to NHibernate with QueryOver
body: <p>I have this SQL query : </p>
  
  <pre><code>select pr.*, det.Description, det.Name 
  from Product pr 
  inner join ProductDetail det on det.Product_id = pr.id
  where pr.Id = XX and det.IsDefault = yy
  </code></pre>
  
  <p>How can I do this with QueryOver ?</p>
  
  <p>Thanks,</p>
  
  <p>Update :</p>
  
  <pre><code>public ProductMap()
  {
      Id(x =&gt; x.Id).GeneratedBy.Native();
      Map(x =&gt; x.Code)
          .Length(20)
          .Not.Nullable();
      Map(x =&gt; x.CreationDate).Not.Nullable();
      Map(x =&gt; x.IsDeleted);
      Map(x =&gt; x.Price);
      HasManyToMany(x =&gt; x.Categories)
          .AsSet()
          .Cascade
          .SaveUpdate()
          .Table("ProductsCategories");
  }
  
  public class ProductDetailMap : ClassMap&lt;ProductDetail&gt;
  {
      public ProductDetailMap()
      {
          Id(x =&gt; x.Id).GeneratedBy.Native();
          Map(x =&gt; x.Name)
              .Length(50)
              .Not.Nullable();
          Map(x =&gt; x.Description)
              .Length(250);
          Map(x =&gt; x.IsDefault);
          References(x =&gt; x.Language);
          References(x =&gt; x.Product);
      }
  }
  </code></pre>