title: Concatenate Rows for one column SQL
body: <p>I am using following query to extract appointment data:</p>
  
  <pre><code>SELECT app.subject, AL.locationName
  FROM FilteredAppointment app
  INNER JOIN appointmentlocation AL ON app.activityid = AL.appointment
  WHERE app.scheduledstart='2013-07-06 15:00:00.000'
  </code></pre>
  
  <p>The output is as follows with 2 rows (same appointment with two different locations):</p>
  
  <p><img src="https://i.stack.imgur.com/9Y5lr.png" alt="enter image description here"></p>
  
  <p>How can i modify this query to display only one row with two locations concatenated with comma like below:</p>
  
  <p><code>Column1:</code> (MZN; OTV)*...<br>
  <code>Column2:</code> Room1,Room2</p>
  
  <p>Thanks</p>