Do you have a question? Post it now! No Registration Necessary. Now with pictures!
October 13, 2006, 5:45 pm
rate this thread
I have two tables: first "points" with id, latitude and longitude, second
"zipcodes" with id, zip, latitude, longitude. Id like to ask the query which
would give me a table with id, zip where id is the id of the point from
points table and zip is the closest zip to this point.
I know that i should use something like
min(abs(point.longitude-zipcodes.longitude)) but i have no clue how to as
the full query.
Thank you very much for your help.
- » Reference to Table Alias in From Clause to be Used by Subquery in Select Clause
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum