title: Having problems with inner joins in LINQ
body: <p>A friend and I, are having some troubles with LINQ</p>
  
  <p>We are trying to display a zipcode where the name of the country is found by a foreign key in the zipcode table.</p>
  
  <p>our LINQ call is as follows </p>
  
  <pre><code>var Zipcodes = from p in db.Zipcodes
     join i in db.ISOes on p.Iso_id equals i.ID
     select new { Zip = p.Zip, name = p.Name, Address = p.Address, Country = i.Country };
  
  return View(Zipcodes.ToList());
  </code></pre>
  
  <p>We where able to display the Zipcode table with the foreign key showing its own value, but trying to use this value to instead display the country name (which is found in the ISOes table)</p>
  
  <p>We get a value cannot be null error (paraname = outer) </p>
  
  <p>LINQ is a new technology to us, so any assistance would be greatly appreciated. </p>
  
  <p>Thanks in advance!</p>
  
  <p>OBS: </p>
  
  <p>We remade some of out code and are stuck at what we think is a different problem. we are going to make a new post about this. Sorry for the wasted time, though we learned alot :) </p>