suppose I have two tables
zips
----
zipcode
city_id (matches city_id in cities table)
latitude
longitude
cities
----
city_id
latitude
longitude
Say I would like to average all the zipcode lat/lons in each city to
get an average latitude and longitude for a city. Then, i would like to
put them in the latitude and longitude columns in the cities table. Is
there a way I can do this with one query?
Thanks.
--
http://www.douglassdavis.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
