Cameron,
I would recommend that you select the objects from one table at a time.
Select * From TABLE1
Where Not OBJ Intersects Any (Select OBJ From TABLE2)
Note the this query can be terrible slow !!! And I mean terrible slow. I can
recommend that you avoid the NOT and simple use a invert selection after doing
this query:
Select * From TABLE1
Where OBJ Intersects Any (Select OBJ From TABLE2)
To my knowledge it should return the same records
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
COWI har fået ny hjemmeside. Ydelserne GIS og IT, kort, kortlægning, 3D
visualisering og arealforvaltning ligger under SAMFUND. Se mere her :
www.cowi.dk
COWI has changed its homepage. Our services within cadastre and
landadministration, geodataproducts, mapping and GIS can be seen under SOCIETY.
See our services here: www.cowi.com
-----Original Message-----
From: Cameron Crum [mailto:[EMAIL PROTECTED]
Sent: Friday, September 09, 2005 4:59 AM
To: MapInfo-L
Subject: MI-L selecting objects from two tables that DO NOT intersect
Is there a way to select all the objects from two tables where thier objects DO
NOT intersect at all? Seems fairly simple but I can't seem to find a "do not
intersect" operator. I doesn't like it when I [put a "not" in front of
intersect.
Cameron
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17797
