query based on long/lat distances

[wattsie]

Hi everybody, I am wondering if you can help.

I have two tables filled with different long/lat co-ordinates, and was wondering how I could create a query that would find the nearest reading on one table based on long/lat reading from another.

If anyone could point me in the right direction I would most appreciate it!

Cheers,
Robert.

 

[tlbroadbent]

This is an intriguing problem. Can you post sample data from the tables and explain how you would determine the nearest reading? Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm