title: more than 2 tables linq to sql join
body: <p>I'm having trouble joining more than 2 tables using linq-to-sql with mysql db (it worked fine with 2 tables):</p>
  
  <p>Here's the code</p>
  
  <pre><code>var s = from rd in context.RegionDetails
                       join r in context.Regions on rd.RegionID equals r.RegionID into tregion
                       join tcr in context.ReceivedFromCollectors on rd.FSa equals tcr.PostalCode1 into tRegDetail
                       select new {rd, tregion, tRegDetail};
  </code></pre>
  
  <p>This is the error I'm getting : 
  Object reference not set to an instance of an object."} System.Exception {System.NullReferenceException}</p>
  
  <p>This is suppose to be a simple query but I couldn't get it to work. Anybody have a guess what might be the problem?</p>
  
  <p>Thanks</p>