title: MySQL concat question
body: <p>I am somewhat mystified by concat and joins in MySQL 4. Here's where I am having an issue.
  I have two tables...</p>
  
  <pre><code>person
  
  id, fname, lname, city, state, zip
  
  
  capital
  
  state, city
  </code></pre>
  
  <p>I am needing to generate all states and the number of persons (from the person table) from each. Something like ....</p>
  
  <pre><code>AK | 5
  
  AL | 7
  
  AZ | 0
  </code></pre>
  
  <p>etc etc
  All states are listed in the capital table but there may be a state like AZ that has no persons.</p>
  
  <p>Any advice would be appreciated. 
  I so rarely am asked to do anything MySQL related and I'm stumped.</p>
  
  <p>Lucy</p>