>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 remove from the list the region "A" just use this exemple: Obj intersects (select obj from regions where name = "A") And name <> "A" Hope this help GH -----Original Message----- From: Vinesh Govind [mailto:[EMAIL PROTECTED] Sent: March 10, 2004 06:42 To: MapInfo Lists (E-mail) Subject: MI-L Touching Polygons This query has probably been asked a few zillion times so please bear with me. I have a dataset of polygons. I would like to select all neighbouring polygons from the topographic polygon database that "touch" my polygons. Is there a simple SQL query to achieve this? Thanks. Vinesh Govind Information Management Team Pen Lloyd Building - Room G48 Chief Executives Department Leicestershire County Council (T) (0116) 265 7321 http://www.leics.gov.uk _______________________________________________________________________ The contents of this message do not necessarily represent the opinions, views, policy or procedures of Leicestershire County Council. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10765
