DaniWeb IT Discussion Community - query to find closest

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- MySQL (http://www.daniweb.com/forums/forum126.html)

- - query to find closest (http://www.daniweb.com/forums/thread159631.html)

dragonflyuk

Nov 26th, 2008 4:51 pm

query to find closest

I have 2 tables with the basic structure

town, latitude, longitude
postcode, latitude, longitude

where latitude and longitude are both floats, and the town and postcode are just descriptive text.

I want a query that will display the closest postcode to each town, is it possible?

All times are GMT -4. The time now is 6:21 am.