Or you could do this way:
Select * from Table1 where not Table1.obj within any Table2.obj
----- Original Message -----
From: David Watkins <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 08, 2000 1:40 AM
Subject: Re: MI Selecting objects not within another - solution
Quite a few of you have emailed me wondering if I found a solution to the
problem
I had in selecting objects. Here is a summary of the advice I was given.
I had unit postcode points for all of Scotland, and a copy of 1991 Census
settlements. I wanted
to use MapInfo to give me all the postcode points that weren't inside any
settlement polygon.
It is so easy to get the ones within the polygons but not so obvious to get
the ones outside.
>From the replies I got the most straightforward way to do it is to enter in
to the SQL select
dialog the following statement (where the postcode point data was Table1 and
the census
settlement polygon file was Table2) :-
Select Columns - *
>From Tables - Table1
Where Condition - not Table1.obj within any (select obj from Table2)
Into Table Named - whatever
So the syntax is:-
Select * from Table1 where not obj within any (select obj from Table2)
Thanks very much to everyone that answered!
David Watkins
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
