title: Linq query for two database tables with three columns
body: <p>I have a problem. I have two tables in my database, both with the same structure. I want to use <code>Union</code> in my Linq query to merge both tables together, but I can't merge them with more then one column. </p>
  
  <p>This is my code:</p>
  
  <pre><code>var result1 = from t in db.table1 select new { t.FieldOne, t.FieldTwo };            
  var result2 = from g in db.table2 select new { g.FieldOne, g.FieldTwo};            
  var combinedTable= result1.Union(result2).ToList();
  </code></pre>
  
  <p>But I get an error. If I do this with just one column for each table, it works.</p>
  
  <p>It would be great if someone can help me to do this with two or more columns :)</p>