title: LinQ Error linq joint type inference failed to call 'join' error
body: <p>I'm quite new to entity framework and I'm trying to use the join clause on two entities as follows.   </p>
  
  <pre><code>var alertlist = from elogAlert  in yangkeeDBEntity.Yang_Kee_Logistics_Pte_Ltd_ELog_Tablet_Alert
                          where elogAlert.No_ != null
                          join elogAlertDetail in  yangkeeDBEntity. Yang_Kee_Logistics_Pte_Ltd_ELog_Tablet_Alert_Details
                          on elogAlert.No_ == elogAlertDetail.AlertID
  
  
  
                          where elogalertdetail.employee_id == driverid
                          select new
                          {
                              elogalertdetail.employee_id,
                              elogalertdetail.alert_id,
                              elogalertdetail.no_,
                              elogalertdetail.status,
                              elogalertdetail.created_by,
                              elogalertdetail.date_created,
  
  
  
                          };
  </code></pre>
  
  <p>Hi from the above code I'm getting two errors saying </p>
  
  <pre><code>'Error  1   The name 'elogAlertDetail' is not in scope on the left side of 'equals'.  Consider swapping the expressions on either side of 'equals'.' and 'linq joint type inference failed to call 'join' error  '
  </code></pre>
  
  <p>Currently the two tables does not have any data. Ill be happy if anyone can help me with this situation</p>