title: Simple Linqpad Linq join statement, select all fields
body: <p>I'm trying to do a simple join query in Linqpad, to mimic the following ...</p>
  
  <pre><code>SELECT *     
  FROM Companies C    
  JOIN Addresses A    
  ON A.CompanyID = C.CompanyID    
  WHERE C.CompanyID = 123
  </code></pre>
  
  <p>I'm using C# Expression (so no need to Dump, AFAIK), and tried the following unsuccessfully ...</p>
  
  <pre><code>from C in Companies    
  join A in Addresses on C.CompanyID equals A.CompanyID    
  where C.CompanyID = 123    
  select C,A
  </code></pre>
  
  <p>So the result is <code>"name does not exist in current context"</code></p>
  
  <p>I suspect it might be because of common field in both tables, or the C,A syntax is basically wrong.</p>
  
  <p>I want to be able to do the splat "*" across both tables. Is this possible? </p>