title: Join one row to multiple rows in another table
body: <p>I have a table to entities (lets call them people) and properties (one person can have an arbitrary number of properties). Ex:</p>
  
  <h2>People</h2>
  
  <pre><code>Name  Age
  --------
  Jane  27
  Joe   36
  Jim   16
  </code></pre>
  
  <h2>Properties</h2>
  
  <pre><code>Name   Property
  -----------------
  Jane   Smart
  Jane   Funny
  Jane   Good-looking
  Joe    Smart
  Joe    Workaholic
  Jim    Funny
  Jim    Young
  </code></pre>
  
  <p>I would like to write an efficient select that would select people based on age and return all or some of their properties.</p>
  
  <pre><code>Ex: People older than 26
  Name Properties
  Jane Smart, Funny, Good-looking
  Joe Smart, Workaholic
  </code></pre>
  
  <p>It's also acceptable to return one of the properties and total property count.</p>
  
  <p>The query should be efficient: there are millions of rows in people table, hundreds of thousands of rows in properties table (so most people have no properties). There are hundreds of rows selected at a time.</p>
  
  <p>Is there any way to do it?</p>