Vinesh
Not sure how to do this with a single in-line query and would love to hear
from someone who does...
The MapInfo operator 'intersect' will give you the answer if you loop the
table in MapBasic - this is how I've done it in the past
Dim i as integer
dim aTemp as alias
dim oTemp as object
a
>From a table called "regions" and column for id is "name" and you want to find the
>region that touches the one region with name=A
Where condiditions:
Obj intersects (select obj from regions where name = "A")
But that will show all the neighbouring AND the region named "A"
And if you want to
Save a copy of the table. SQL table1 where intersects table2. The output
will be a query that lists all polygons that border each other.
Kent Treichel
Analyst-GIS
Tax Research
Minnesota Department of Revenue
MS 2230
600 North Robert St
St. Paul, MN 55146-2230
651-556-6150
|---