average numbers, put in another table

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

Re: average numbers, put in another table

[EMAIL PROTECTED] wrote on 01/16/2006 03:46:32 PM: 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