title: SQL Server 2008 combine multiple rows into 1 with commas + 3 tables
body: <p>I have 3 tables:</p>
  
  <p><strong>MovieDB</strong></p>
  
  <pre><code>movieID | Title
  1       | Star War
  </code></pre>
  
  <p><strong>StarringDB</strong></p>
  
  <pre><code>movie ID | nameID
  1        | 1
  1        | 2
  1        | 3
  1        | 4
  1        | 5
  </code></pre>
  
  <p><strong>nameDB</strong></p>
  
  <pre><code>nameID | Name
  1      | Harrison Ford
  2      | Mark Hamill
  3      | Carrie Fisher
  4      | Peter Cushing
  5      | Alec Guinness
  </code></pre>
  
  <p>I'd like the output to be:</p>
  
  <pre><code>ID | Title    | Starrings
  1  | Star War | Harrison Ford, Mark Hamill, Carrie Fisher, Peter Cushing, Alec Guinness
  </code></pre>