Try this:
Select * From TABLE2
Where NOT OBJ WithIn Any (Select OBJ From TABLE1)
HTH,
Peter Horsb�ll M�ller
GIS Developer
COWI A/S
Rug�rdsvej 55
DK 5000 Odense C
Tel +45 6313 5013
Direct +45 6313 5008
Mobil +45 2270 4308
Fax +45 6313 5090
-----Original Message-----
From: Brandi McGunigal
To: MapInfo List
Sent: 17-02-03 21:51
Subject: MI-L Geographic Operators
To List,
I am running MapInfo 4.1 and do not have MapBasic.
I want to perform a geographic operator on two files. Here is an
example statement to issue in the MBW:
select * from table1,table2 where table1.obj contains
table2.obj.
However, I want to find where objects from table2 are NOT contained in
table1.
I am unsure how to form this statement. When I try typing not in front
of contains I get an error.
Any help would be appreciated. Thanks in advance.
Brandi McGunigal
GIS Technician
Traxis Inc.
Saskatoon, SK
(306) 978-0445
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 5549
