title: NHibernate.QueryException: not an association: Id
body: <p>I wrote a joint query using NHiberNate, but I am getting a NHibernate.QueryException:not an association: Id</p>
  
  <p>This is what it looks like with NHibernate library</p>
  
  <pre><code>TicketRequest ticketAlias = null;
          Show showAlias = null;
  
          IList&lt;TicketRequest&gt; results = UnitOfWork.CurrentSession.QueryOver&lt;TicketRequest&gt;(() =&gt; ticketAlias)
                    .JoinAlias(() =&gt; ticketAlias.ShowId, () =&gt; showAlias.Id)
                    .Where(() =&gt; showAlias.ShowDate &gt;=DateTime.Now)
                    .List();
  
          return results;
  </code></pre>
  
  <p>I just want a simple joint statement, and this is what it would have been in SQL</p>
  
  <pre><code>select * from TicketRequest as a join Show as b
  on a.Show_id = b.Id
  where ShowDate &gt;=GETDATE()
  </code></pre>
  
  <p>Can someone help and let me know why I am getting a "not an association:Id" error. I have id in the "Show" table, it is a primary key. </p>
  
  <p>Please advise. All helps are greatly appreciated.</p>