title: SQL - Concat multiple rows into 1 on a join
body: <p>So I've got 2 tables which looks like the below:</p>
  
  <p>MetaData</p>
  
  <pre><code>Id       | Value
  ---------------------
  1       | 5
  1       | 6
  2       | 6
  </code></pre>
  
  <p>LookUp</p>
  
  <pre><code>Value    | Text
  ---------------------
  5       | Car
  6       | Truck
  </code></pre>
  
  <p>I need a query to pull out the Id from MetaData and the text from Lookup
  so e.g.</p>
  
  <pre><code>Id | Text
  ---------
  1  | Car, Truck
  2  | Truck
  </code></pre>
  
  <p>Any ideas on how I can do this?
  Thanks!</p>