Member Avatar for dragonflyuk
dragonflyuk 0 Newbie Poster

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?

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.