title: sql server sub query with a comma separated resultset
body: <p>I need to return records on a table and my result set needs to contain a comma separated list. </p>
  
  <p>I have attached an image of the 3 tables.  I need to do a select that returns the record in the first table and include the last of AwardFocusName that exist in the 3rd table in the screenshot.</p>
  
  <p>So my result set would return one record and include the list of AwardFocusNames in it (comma separated).</p>
  
  <p><img src="https://i.stack.imgur.com/wFCle.png" alt="enter image description here"></p>