title: How do I get a count of items in one column that match items in another column?
body: <p>Assume I have two data tables and a linking table as such:</p>
  
  <pre>
  
  A         B         A_B_Link          
  -----     -----     -----
  ID        ID        A_ID
  Name      Name      B_ID
  
  </pre>
  
  <p>2 Questions:</p>
  
  <ol>
  <li><p>I would like to write a query so that I have all of A's columns and a count of how many B's are linked to A, what is the best way to do this?</p></li>
  <li><p>Is there a way to have a query return a row with all of the columns from A and a column containing <em>all</em> of linked names from B (maybe separated by some delimiter?)</p></li>
  </ol>
  
  <p>Note that <strong>the query must return distinct rows from A</strong>, so a simple left outer join is not going to work here...I'm guessing I'll need nested select statements?</p>