MySQL concat question
- by Lucy Williard
Hi guys! I am somewhat mystified by concat and joins in MySQL 4. Here's where I am having an issue.
I have two tables...
person
id, fname, lname, city, state, zip
capital
state, city
I am needing to generate all states and the number of persons (from the person table) from each. Something like ....
AK | 5
AL | 7
etc etc
Any advice would be appreciated.
I so rarely am asked to do anything MySQL related and I'm stumped.
Lucy