title: OrmLite query to select some of the columns from each of 2 joined tables
body: <p>Following on from <a href="https://stackoverflow.com/questions/37416424/how-do-i-join-2-tables-in-servicestack-ormlite-and-select-both-classes/37420341?noredirect=1#comment62383922_37420341">this comment</a>, how can I do a ServiceStack OrmLite query that joins two or more tables and returns some of the columns from each of them?</p>
  
  <p>Using the OrmLite <code>Does_only_populate_Select_fields_wildcard</code> unit test as example, I'd like to do something like this:</p>
  
  <pre><code>public class DeptEmployee
  {
      [PrimaryKey]
      public int Id { get; set; }
      public string FirstName { get; set; }
      public string LastName { get; set; }
      [References(typeof(Department2))]
      public int DepartmentId { get; set; }
  
      [Reference]
      public Department2 Department { get; set; }
  }
  
  public class Department2
  {
      [PrimaryKey]
      public int Id { get; set; }
      public string Name { get; set; }
  }
  
  var q = db.From&lt;DeptEmployee&gt;()
      .Join&lt;Department2&gt;()
      .Select&lt;DeptEmployee, Department2&gt;((de, d2) =&gt; new[] { de.FirstName, de.LastName, d2.Name });
  var results = db.Select(q);
  </code></pre>
  
  <p>The above does not return a list of anonymous types containing FirstName, LastName and Name, as I'd expect. It still returns a list of <code>DeptEmployee</code> objects (but with only FirstName and LastName populated).</p>