title: Unable to join a table and view - type inference failed in the call to 'join'
body: <p>I want to inner join my table column <code>EmployeeAccess.EmpNo</code> to my view column <code>VIEW_HCM.EmpNo</code>.</p>
  
  <pre><code>public List&lt;EmployeeAccess&gt; EmployeeAccess4()
  {
      var emp = from b in contxt.EmployeeAccesses
                join c in contxt.View_HCM on b.EmpNo equals c.EmpNo
                select new                     
                {
                    b.EmpNo,
                    c.EmailAddress
                };
  
  }
  </code></pre>
  
  <p>I get error with <code>join</code>:</p>
  
  <blockquote>
    <p>The type of one of the expressions of this joint clause is incorrect. Type inference failed in the call to 'join'.</p>
  </blockquote>