SELECT geo_cities.*
    FROM geo_cities, puppy_listings 
   WHERE geo_cities.city_id = puppy_listings.city_id 
GROUP BY geo_cities.city_name
ORDER BY geo_cities.city_name ASC