Hi
Look at ToolBox which includes such a tool and also a description on how to
do it in SQL.
www.routeware.dk/download/toolbox.zip
The SQL description can also be used as a basis for selecting within 10 km.
Kind regards
Uffe Kousgaard
www.routeware.dk
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 3:47 PM
Subject: MI-L Finding the two nearest neighbors in two tables of points
> Dear Listers,
>
> Are there some SQL wizards out there who knows how to do this:
>
> I have two tables containing points. Lets say table X and table Y.
>
> All points in Table X are in country X and all points in table Y are on
> the other side of the country border in the neighboring country Y.
>
> For each and every point in table X I want to select the to nearest
> points in table Y and vice versa.
> And then again select points and neighboring points in the first
> selection/query that are not more than for example 10 kilometers away
> from each other.
>
> Any suggestions?
>
>
>
>
> TIA
> Alf
>
> ______________________________________________
> Alf R. Austrheim
> Network engineer
>
> NetCom GSM as
> Norway
>
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
