title: How do I join two tables on a common column name where 1 table has multiple rows of text I need to concatinate?
body: <p>I'm trying to return one row result on a.OrderNumber = b.OrderNumber where table b has multiple lines of service comments.  Will I need to concatenate the comments into one field result to prevent multiple rows and how do I do that?  Here is what I have.</p>
  
  <pre><code>SELECT a.OrderNumber,
      b.Comment,
      b.Comment,
      b.DATE
  FROM Orders a
  LEFT JOIN Comments b ON a.OrderNumber = b.OrderNumber
  </code></pre>
  
  <p>I'm looking for:</p>
  
  <pre><code>   OrderNumber            Comment
     1200         01-01-13 Repair made, 01-02-13 Billed Customer
  </code></pre>
  
  <p>What I get is:</p>
  
  <pre><code>OrderNumber            Comment            Date
  1200              Repair made        01-01-13
  1200              Billed Customer    01-02-13
  </code></pre>
  
  <p>Here's the result I currently have:</p>
  
  <p><img src="https://i.stack.imgur.com/HD7mY.jpg" alt="enter image description here"></p>