title: Need help writing a SQL query to combine some fields
body: <p>I am currently trying to get my head around a sql script to export some data, I have a table in a database that looks something like this:</p>
  <pre><code>Part_No       Op_No       Tool_No
  110301         10          PPG220
  110301         10          PPG221
  110301         10          PPG222
  110301         20          PPG220
  110301         20          PPG221
  1103012        10          PPG220
  1103012        10          PPG224
  1103012        10          PPG228
  </code></pre>
  <p>What I would like to do is export each part number so it looks more like this:</p>
  <pre><code>Part_No       Op_No       Tool_No
  110301         10          PPG220,PPG221,PG222
  110301         20          PPG220,PPG221
  1103012        10          PPG220,PPG224,PPG228
  </code></pre>
  <p>Combining each of the Tools into one line based on the Part and Op number.</p>
  <p>Help?</p>
  <p>Cheers..</p>
  <p>(I am not sure how to format the columns as this is my first post on this site)</p>