title: How To Join Two Tables In Nhibernate
body: <pre><code>List&lt;object[]&gt; olist = null;
  
  olist = (_session.CreateQuery(&quot;Select pc.Id as Id, &quot; + 
      &quot;pct.DescEn as DescEn,pct.DescAr as DescAr, pc.ContentEn as ContentEn,&quot; + 
      &quot;pc.ContentAr as ContentAr &quot; + 
      &quot;from ProjectCharter pc,ProjectCharterTemplate pct &quot; + 
      &quot;where pct.Id=pc.PRC_PCT_ID &quot; + 
      &quot;and pc.PRC_PRJ_ID=1&quot;)
  .List&lt;object[]&gt;())
  .ToList&lt;object[]&gt;();
  </code></pre>
  <p>This is My Query, I want to join two tables and get an output,
  when i run this is the db i get the perfect answere,
  but when i run it through c# with nhibernate mapping. i get errors.</p>
  <p>Can i query this way or is there any other method to join two tables.</p>
  <p>Thanks in advance.</p>