Mapinfo SQL ClientxStore Minimum Distance

183 Views Asked by At

I have two tables in mapinfo:

Client ( Id, X, Y, storeId)
Store (StoreId, StoreName, X, Y)

I need to get closest Store (minimum distance between client and store) to every client and store it into Client table, I can't use excel, spss or anything else than mapinfo.

Do you have any idea?

0

There are 0 best solutions below