I have a made a query which as far as I can tell, returns the data that it should. The issue I have is that it is telling me an incorrect distance.
This is the join part of the query:
I can't see anything wrong there so, maybe my statement which inserted the values for latitude_miles and longitude_mpd was wrong?
any pointers are welcome.