title: How to accumulate matches when querying multiple tables in SQLite?
body: <p>Table1</p>
  <pre><code>ID     Name     CourseID
  1     Course 1   4002
  2     Course 2   2342
  3     Course 3   2410 
  </code></pre>
  <p>Table2</p>
  <pre><code>CourseID ProfName
  4002     John
  2342     bob 
  2410     Bill
  4002     Hannah
  2342     Cyrus 
  </code></pre>
  <p>When I try</p>
  <pre><code>SELECT ID, Name, CourseID, ProfName 
  FROM Table1, Table2
  WHERE Table1.CourseID = Table2.CourseID 
  </code></pre>
  <p>I get multiple instances for the same CourseID returned  such that when I print it out</p>
  <p>&quot;1, Course 1, 4002, John&quot;  and</p>
  <p>&quot;1, Course 1, 4002, Hannah&quot; are two different outputs.</p>
  <p>I would like them to be of the form</p>
  <p>&quot;1, Course 1, 4002, <strong>John and Hannah</strong>&quot;</p>
  <p>Not sure how to alter my SQL query to make this happen?</p>