title: Creating a LINQ select from multiple tables
body: <p>This query works great:</p>
  
  <pre><code>var pageObject = (from op in db.ObjectPermissions
                    join pg in db.Pages on op.ObjectPermissionName equals page.PageName
                    where pg.PageID == page.PageID
                    select op)
                   .SingleOrDefault();
  </code></pre>
  
  <p>I get a new type with my 'op' fields.  Now I want to retrieve my 'pg' fields as well, but</p>
  
  <pre><code>select op, pg).SingleOrDefault();
  </code></pre>
  
  <p>doesn't work.</p>
  
  <p>How can I select everything from both tables so that they appear in my new pageObject type?</p>