title: Merge duplicate records into 1 field
body: <p>I have a database table that contains a list of contacts, some of those contacts might have multiple records, e.g.</p>
  
  <pre><code>CustomerID, CustomerName, Vehicle
  1, Dan, Mazda
  1, Dan, Suzuki
  2, John, Ford
  3, Dasha, Volvo
  3, Dasha, Ford
  </code></pre>
  
  <p>Can I write a select query to return the distinct customerID and CustomerName, and a list of vehicles in 1 record? i.e.</p>
  
  <pre><code>1, Dan, Mazda+Suzuki
  2, John, Ford
  3, Dasha, Volvo+Ford
  </code></pre>
  
  <p>Thanks</p>