Stephen, Lets say you have a table with polygons and a tables with points
then the SQL is:- Select * from points where not obj within any (select obj from polygon) into Selection However this runs really sloww on large tables....... So you if you are using Version 6.5 you could join the two table using a within or contains clause and then run the invert selection command. This would be a lot quicker than my SQL above! Hope this helps Regards Martin ----- Original Message ----- From: "Brooks, Stephen" <[EMAIL PROTECTED]> To: "Mi-L (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 5:37 PM Subject: MI-L SQL > Hi, > > Anyone know how to find all points NOT contained within a polygon? > > TIA > > Stephen Brooks > Steer Davies Gleave > 28-32 Upper Ground > London > SE1 9PD > > [tel] +44 (020) 7919 6781 > [fax] +44 (020) 7827 9851 > [email] [EMAIL PROTECTED] > > www.steerdaviesgleave.com > > > > _______________________________________________________________________ > 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.
