Hi, This should do the trick, even though it might be pretty slow:
Select * From ONETABLE Where NOT OBJ Within ANY (Select Buffer(OBJ, 12, 100, "m") From ANOTHERTABLE) This would select all the records from ONETABLE that are more than 100 meters from any point in ANOTHERTABLE. You could also do it this way: Select * From ONETABLE Where OBJ Within ANY (Select Buffer(OBJ, 12, 100, "m") From ANOTHERTABLE) Click on "Invert Selection" The later is quite a lot quicker than the first Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Bettenay Sent: Wednesday, February 15, 2006 2:37 AM To: Mapinfo-L@lists.directionsmag.com Subject: [MI-L] Identifying points greater than x metres from ANY point inanother table Can anyone help me with this simple little problem? I have two point coverages and I want to identify all those points in one table that are more than a specified distance from ANY point in the other table. I could do this by buffering one table, then identifying those points inside buffered regions then inverting the selection. However, I suspect there might be a quicker and sneakier way. Any thoughts would be gratefully welcomed. Leigh Bettenay Chief Geologist Sipa Resources Ltd Level 2, 87 Colin St, WEST PERTH WA 6005 Tel: 08 94816259 Fax: 08 9322 3047 Mobile: 04388 17616 Email: [EMAIL PROTECTED] =========================== _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
