Hi,
Sue Port is right.
The other method is: Select all the objects which are within the relation1 and delete them - you will end up with objects which are outside. But remember to save the copy of the original table. Although this is not a very professional option it is much quicker than any other. Selecting not objects which are within any takes a lot of time and it is better to leave the computer to work over lunchtime or even over night if this is a few thousands record table.
 
Ewa
----- Original Message -----
Sent: Monday, September 06, 1999 12:52 PM
Subject: MI Objects Outside

Hi Listers,
 
I am fighting with the following problem:
I have two files and want to select all Objects from file#1 that do not lie within objects of file#2.
Unfortunately, there is geographical operand "Within", but no operand "OutSide".
What is the correct SQL-syntax for that problem?
I tried "Select * From relation1, relation2 where NOT (relation1.obj Within relation2.obj)", but it didn't work.
 
Thanks a lot for your help!
Markus V.

Reply via email to