<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>

You must create a new anonymous type:
```
```
select new { op, pg }
```
```
Refer to the official
guide
.