title: LINQ Inner Join - Return From Both Tables
body: <p>I have the following query</p>
  
  <pre><code>var customers = from customer in context.tblAccounts 
                  join assoc in context.tblAccountAssociations on customer.AccountCode equals assoc.ChildCode 
                  where customer.AccountType == "S" || customer.AccountType == "P" 
                  select customer, assoc;
  </code></pre>
  
  <p>C# does not like the  "assoc" at the end.</p>
  
  <p>My error message is:</p>
  
  <p>A local variable named 'assoc' cannot be declared in this scope because it would give a different meaning to 'assoc', which is already used in a 'child' scope to denote something else.</p>
  
  <p>I need to return all columns from both table and then iterate with a </p>
  
  <p>foreach (var customer in customers)</p>