dr john, don't confuse the guy by optimizing everything right away plz

he's trying to learn many-to-many relationships

curtis, the query in post #22 is fine

i'm willing to bet the cities table isn't actually what you've shown us

please run this query and show what it produces:
Code:
SHOW CREATE TABLE cities