Geo Coordinates calculating

[Rainer Parzer]

Hi

First of all ... I'm new to mysql :)

And here is my "Problem".

Lets say i have 5 tables (in reality a lot more).
Each table contains an ID , Latitude and Longitude (in decimal format).
The Tables gets updated every 30 seconds .... so the actual position is always in the last line of the table.
And there is also a timestamp in each line.

Table1:
'123456','10.34411','18.12345','2018-06-15 16:19:16'
'123456','10.34411','18.12345','2018-06-15 16:19:30'
'123456','10.34411','18.12345','2018-06-15 16:29:48'
'123456','10.34411','18.12345','2018-06-15 16:34:45'
'123456','10.34411','18.12345','2018-06-15 16:35:22'

Table2:
'654321','12.34411','15.12345','2018-06-15 16:19:16'
'654321','12.34411','15.12345','2018-06-15 16:19:30'
'654321','12.34411','15.12345','2018-06-15 16:29:48'
'654321','12.34411','15.12345','2018-06-15 16:34:45'
'654321','12.34411','15.12345','2018-06-15 16:35:22'

Table3:
'567891','17.34411','28.12345','2018-06-15 16:19:16'
'567891','17.34411','28.12345','2018-06-15 16:19:30'
'567891','17.34411','28.12345','2018-06-15 16:29:48'
'567891','17.34411','28.12345','2018-06-15 16:34:45'
'567891','17.34411','28.12345','2018-06-15 16:35:22'

what i would like to is:
calculate the distance from the most recent entry from 1 to 2 to 3 and from 2 to 1 to 3 and from 3 to 1 to 2 and so on


Thanks a lot for helping
rainer